Thread: How do I add a second criteria to the SUMIF or DSUM function?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default How do I add a second criteria to the SUMIF or DSUM function?
You can't but you could use a SUMPRODUCT function to accomplish the
same thing. Try:

=SUMPRODUCT(--(A1:A10="A"), --(B1:B10)="B",C1:C10)

Hope that helps.

- John Michl

Reply With QuoteReply With Quote