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



I am trying to calculate the total of one cell (i5) of twelve months to get a yearly total. My formula was =SUM('January I5:DecemberI5!C30") does not work? I get #Name? How do you create the correct formula? 

