Adding numbers in column if yes is written to right

T

Turnipboy

I have a column of numbers which I what to sum, which i
straightforward. However I also want to sum only those numbers in th
same column which have 'Yes' written in the cell to the right, whic
only some have. How would I do this
 
R

Ron Coderre

Try this (for cells A1:B10):
A11: =SUMIF(B1:B10,"Yes",A1:A10)

Does that help?

Ro
 
Top