Count Function

[JJP]

HI

How can I count data in colums or rows without counting duplicat
values.

Thank Yo

 

[Peo Sjoblom]

One way

=SUMPRODUCT((A1:A100<>"")/COUNTIF(A1:A100,A1:A100&""))

 

[JJP]

Thanks Peo