Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
 

I want to single out a sum that has two common detonators row A and B, IF row
A=1 and row B=2 then sum row C

Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
 

Try this, adjust the range to match your data:

=SUMPRODUCT(--(A1:A100=1), --(B1:B100=2), C1:C100)

Does that help?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Peter" wrote:

I want to single out a sum that has two common detonators row A and B, IF row
A=1 and row B=2 then sum row C

Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
 

That's quite an explosive worksheet you have<g


Gord Dibben MS Excel MVP

On Thu, 19 Nov 2009 12:31:02 -0800, Peter
wrote:

I want to single out a sum that has two common detonators row A and B, IF row
A=1 and row B=2 then sum row C