SUM Functions with multiple criteria

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.
 
P

pinmaster

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
 
Top