Adding numbers in column if yes is written to right

[Turnipboy]

I have a column of numbers which I what to sum, which is straightforward. However I also want to sum only those numbers in the same column which have 'Yes' written in the cell to the right, which 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?

Ron

[Turnipboy]

Thanks, worked a treat