This is my Google Sheet.

I have a number of "shopping" cells formatted to have a dropdown list of products/words using the (right-click) "data validation" function.

I have another cell I want to come up with a total price of all the products chosen from the various "shopping" cells, given each product/word has a defined number value/price.


cell 1 chooses "widget1"
cell 2 chooses "widget4"
cell 3 chooses "widget7"

widget1 costs 10
widget4 costs 13
widget7 costs 25

Finally, I want a total price cell to show the total price of all the products chosen.

  • can you allow editing? Done – Pete Mar 2 '19 at 4:57
 IFERROR(VLOOKUP(A8:A, E2:F4, 2, 0), 0)+
 IFERROR(VLOOKUP(B8:B, G2:H4, 2, 0), 0)+
 IFERROR(VLOOKUP(C8:C, I2:J4, 2, 0), 0), ))}


  • @MARKMYANSWER what does LEN mean? – ahorn Mar 3 '19 at 19:37
  • @ahorn LEN counts characters in given cell/range so it's kinda equivalent to IF(A8:A<>"", – user0 Mar 3 '19 at 19:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.