Sumproduct question

[wx4usa]

I have column A as year, column B as "yes" or "no", column C as a $
amount.

How do I do a sumproduct of year=2007, col B=yes, the total the $ in
col C?

$ total for both Yes and 2007?

Am I making sense?

 

[Dallman Ross]

I have column A as year, column B as "yes" or "no", column C as a
$ amount.

How do I do a sumproduct of year=2007, col B=yes, the total the $
in col C?

=SUMPRODUCT(($A$2:$A$20=2007)*($B$2:$B$20="yes")*$C$2:$C$20)

is one way. Change the ranges to suit.