P Peter Nov 19, 2009 #1 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
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
J JBeaucaire Nov 19, 2009 #2 Try this, adjust the range to match your data: =SUMPRODUCT(--(A1:A100=1), --(B1:B100=2), C1:C100) Does that help?
Try this, adjust the range to match your data: =SUMPRODUCT(--(A1:A100=1), --(B1:B100=2), C1:C100) Does that help?
G Gord Dibben Nov 20, 2009 #3 That's quite an explosive worksheet you have<g> Gord Dibben MS Excel MVP
