I am trying to match names (with many duplicates) in a sheet2, with a list of
names (no duplicates) in a Summary Sheet. Then for each name, count unique
numbers in columnG, of sheet2 ONLY IF, the dollar value in columnV is 0.

This is my function:
=SUMPRODUCT((sheet2!$C$2:$C$678=C56)/COUNTIF(sheet2!$G$2:$G$678,sheet2!$G$2:$G$678&"")* sheet2!$V$2:$V$6780)

The logic seems right to me, but Im getting all zeros and I know some of
the conditions that I mentioned above are true so I should not have all zeros.

Any ideas?

Thanks,
Ryan---


--
RyGuy