Adding numbers in column if yes is written to right

[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

 

[Ron Coderre]

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

Does that help?

Ro

 

[Turnipboy]

Thanks, worked a trea