try:

=SUM(1/COUNTIF(INDIRECT("A1:F"&G1),INDIRECT("A1:F"&G1)))
=SUM(IF(FREQUENCY(INDIRECT("A1:F"&G1),INDIRECT("A1 :F"&G1))0,1))


Regards
Claus B.

Hmm, this one gives me a #DIV/0!
I tried C + S + E to enter also, but still gives dividing by 0

=SUM(1/COUNTIF(INDIRECT("A1:F"&G1),INDIRECT("A1:F"&G1)))

The other works well. The " "'s are very tricky indeed!

Thanks, guys.

Howard