I have a list of prices and sum them up in a cell at the right.

Next to some prices I have the work "select".

How do I calculate the sum of all prices which next to them have the word "select"?

enter image description here


You can use the function Sumifs()

  • thanks, this is what worked for me: =SUMIFS(A3:A30;B3:B30;"=select") – Edward Tanguay Aug 5 '11 at 10:22

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.