If you want to look at the columns use the following as SUMPRODUCT doesn't
allow you specify column as (e.g.) A:A

=SUMPRODUCT(--(A1:A65535=value1),--(B1:B65535=value2),--(C1:C65535))

"Ron Coderre" wrote:

Try something like this:

D1: =SUMPRODUCT((A1:A100=3)*(B1:B100=10)*(C1:C100))

Adds the valued in C1:C100
where the corresponding Col_A value is 3
and the corresponding Col_B value is 10

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"knbsmith11" wrote:

Is there a formula to say if column A = X and if column B = Y, then take the
sum of column C and place it in this cell?