Need help with triple sumproduct, please

**cmdill** · 07-03-2013, 08:19 PM

I am trying to use the sumproduct formula with 3 criteria, but it is not totally working.
Here is what I have:

=SUMPRODUCT(('Entry Table'!M4:M18016>0)*('Entry Table'!N4:N18016="PASS")*('Entry Table'!E4:E18016="Yeast/Mold"))

I want to count the number of entries that have three things in common: a column M value greater than 0, a column N value of "PASS", and a column E value of "Yeast/Mold".

The formula is counting column M values that are equal to zero. Can someone help me fix it so that it only counts when column M values are greater than zero? Thank you for your help!

**FDibbins** · 07-03-2013, 08:22 PM

Hi and welcome to the forum

Try countifS() instead...

=COUNTIFS('Entry Table'!M4:M18016,">0",'Entry Table'!N4:N18016,"PASS",'Entry Table'!E4:E18016,"Yeast/Mold")

If that doesnt work, upload a sample workbook