How do I get the sum of a column but with a qualification?

[icebearmonster]

I want to get the sum of column B , but only those rows which have a YES/Check in column C.

For example, B1 to B4 have the numbers 1, 2, 3, and 4 respectively. But only C2 and C4 have a YES/Check. Thus, I want to use a formula where I get the sum only of B2 and B4, since they correspond to the C column with a YES/Check. This should result in 6 (2+4).

Of course it's easy to do it manually in smaller scale, which is =sum(b2,b4), but when the table gets lengthy i need to automate it.

Thanks for the help!

[avk]

Please Login or Register  to view this content.