Thread: Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBeaucaire[_131_] JBeaucaire[_131_] is offline
external usenet poster
  
Posts: 96
Default 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
Reply With QuoteReply With Quote