Count non-empty cells, but don't count if repeat

[cgmojoco]

Subject describes it all
I have:

 =COUNTA(C3:C100)

But if more than one cell contains the same value, I don't want to count it more than once, only once...how would I do this?

Thank you in advance

 

[tactps]

Courtesy of Fairwinds:

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

 

[Aladin Akyurek]

Courtesy of Fairwinds:

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

Fine to acknowledge, but wrong attribution.

 

[fairwinds]

To set things straight:

http://www.mrexcel.com/board2/viewtopic.php?t=73502&highlight=

 

[cgmojoco]

=SUMPRODUCT((C3:C100<>"")/COUNTIF(C3:C100,C3:C100&""))

Ok, thanks that did the trick, now I need to know how to exclude 0's from registering as a counted item.

DOH, nevermind, I just needed to add -1 at the end

 

[Aladin Akyurek]

=SUMPRODUCT((C3:C100<>"")/COUNTIF(C3:C100,C3:C100&""))

Ok, thanks that did the trick, now I need to know how to exclude 0's from registering as a counted item.

DOH, nevermind, I just needed to add -1 at the end

You mean of course:

SUMPRODUCT(...)-(COUNTIF(C3:C100,0) > 0)

A fast alternative is:

=COUNTDIFF(A1:A6,FALSE,0)

if you download and install the morefunc.xll add-in.