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"?
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"? 


You can use the function


