Hi all,

Im a bit stumped on this, and would appreciate someone telling me what I have done wrong. Basically I need to count the number of unique names after multiple criteria. I thought this would work, but it doesn't seem to give the right answer

`=SUMPRODUCT(('YR2011'!V2:V1687>B2)*('YR2011'!V2:V1687<=C2)*('YR2011'!BP2:BP1687<>"")*('YR2011'!BP2:BP1687>0)*('YR2011'!$C$2:$C$1687<>"")/COUNTIFS('YR2011'!$C$2:$C$1687,'YR2011'!$C$2:$C$1687&"",'YR2011'!$V$2:$V$1687,'YR2011'!$V$2:$V$1687&"",'YR2011'!$V$2:$V$1687,'YR2011'!$BP$2:$BP$1687&""))`

YR2011 Column V gives length, YR2011 Column C is the name of manufacturer which I am trying to count the number of unique values for, B2 and C2 are length that manufacturer gives which is between 20 and 30, and YR2011 column BP is the number of units sold as I only want to count manufacturers that sell anything. The data can include blanks for any criteria, but if possible this should be ignored in the calculations.

A swift response would be appreciated as I have spent all afternoon on this and im being questioned why it is so difficult!