How do I add a second criteria to the SUMIF or DSUM function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2003 and I need to write a function to select numbers in a
column based on two separate criteria and then sum those selected numbers. I
have tried SUMIF and DSUM but either these functions will not allow a second
criteria to be added or I am doing it wrong. Any suggestions would be
appreciated
 
Sumif doesn't support multiple criteria (you'd have to use sumproduct
instead, generate arrays of true/false which get converted to 1/0). DSUM
certainly supports multiple criteria. Your criteria range would have to be
multiple columns, with the column headers matching those columns of your data
range you want to filter.
Could you provide more info, say what you've got so far and what you're
trying to do?
--Bruce
 
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
 
Back
Top