SUM Functions with multiple criteria

  • Thread starter Thread starter readystate
  • Start date Start date
R

readystate

I have been using the following formula for adding certain cells based on two
criteria:

=SUMPRODUCT(--($H$3:$H$1352="PRODUCT
TYPE"),--($J$3:$J$1352="NEW"),($Q$3:$Q$1352))

This has functioned fine, however, now I need to add another criteria - ex -
I need to include ($F$3:$F$1352="AP") to the formula as an additional
criteria to filter before adding Q3:Q1352. When I try to add this to the
formula above, I get #REF!. Any suggestions on how to properly format the
above formula to include the additional criteria would be greatly
appreciated.
 
Hi,

Just can't think of any reason why the formula would return #REF.

Try this:

=SUMPRODUCT(($H$3:$H$1352="PRODUCT
TYPE")*($J$3:$J$1352="NEW")*($F$3:$F$1352="AP"),$Q$3:$Q$1352)

or

=SUMPRODUCT(--($H$3:$H$1352="PRODUCT
TYPE"),--($J$3:$J$1352="NEW"),--($F$3:$F$1352="AP"),$Q$3:$Q$1352)

HTH
Jean-Guy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Access Dcount (multiple criteria) 3
Add from multiple criteria in a range 5
one of two criteria 11
STDEVP function with an array 2
Sum data with multiple criteria 1
Require formula to search across multiple worksheets 2
Sumproduct;3 criteria 5

Back
Top