How to calculate sum based on cells that have a specific text next to them?

Question

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

slhck · Accepted Answer · 2011-08-05 10:11:01Z

6

You can use the function Sumifs()

=SUMIFS(A:A,B:B,"=select")

slhck

228k71 gold badges615 silver badges601 bronze badges

answered Aug 5, 2011 at 10:09

Qbana44

761 bronze badge

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

Add a comment |

1 Answer 1