Try this:

=SUMPRODUCT(--(A1:A4=2),--(B1:B4=75),C1:C4)

Better to use cells to hold the criteria:

E1 = 2
F1 = 75

=SUMPRODUCT(--(A1:A4=E1),--(B1:B4=F1),C1:C4)

--
Biff
Microsoft Excel MVP


"cudan" wrote in message
...
Column_A Column_B Column_C
2 75 250
2 75 500
3 76 350
4 70 1000

I want to add up column C, if column_A = 2 and column_B = 75. Can someone
help me out with this?

Thanks