Count Uniques with a Couple Conditions
 

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

Count Uniques with a Couple Conditions
 

This is getting close, but it counts only uniques in ColumnG, not the uniques
in ColumnG which have a value in the ColumnV of the same row that is grteater
than 0:
=SUMPRODUCT(--(sheet2!$C$2:$C$678=C58)*(1/COUNTIF(sheet2!$G$2:$G$678,sheet2!$G$2:$G$678)*she et2!$V$2:$V$6780))


--
RyGuy


"ryguy7272" wrote:

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

Count Uniques with a Couple Conditions
 

Finally got it!
=COUNT(1/FREQUENCY(IF(sheet2!$C$2:$C$1000=C56,sheet2!$G$2:$ G$1000),sheet2!$G$2:$G$1000))-(SUMPRODUCT((sheet2!$C$2:$C$1000=C56)*(sheet2!$V$2 :$V$1000<=0)))


--
RyGuy


"ryguy7272" wrote:

This is getting close, but it counts only uniques in ColumnG, not the uniques
in ColumnG which have a value in the ColumnV of the same row that is grteater
than 0:
=SUMPRODUCT(--(sheet2!$C$2:$C$678=C58)*(1/COUNTIF(sheet2!$G$2:$G$678,sheet2!$G$2:$G$678)*she et2!$V$2:$V$6780))


--
RyGuy


"ryguy7272" wrote:

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