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.