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?