Sumproduct question
 

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?

Sumproduct question
 

In .com, wx4usa
spake thusly:

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.

--
dman