Thread: sumif/if with conditions "HELP"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default sumif/if with conditions "HELP"

Not sure if this is what you are getting at but SUMPRODUCT could work.

=SUMPRODUCT((Data1!A4:A291=summary!B1)*(Data1!G4:G 291=A12)*(Data1!1I4:I291))

and

=SUMPRODUCT((Data2!A4:A291=summary!B1)*(Data2!G4:G 291=A12)*(Data2!1I4:I291))

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=516340

Reply With QuoteReply With Quote