Tally Unique Numbers?

[Gerry Kuta]

By way of example, if in B8:B15 you have
10,20,10,10,30,40,50,60 ...unique is 210. OR,
You can do it semi-automatically using another column if
it helps...
=INDEX($B$8:$B$15,MATCH(0,COUNTIF(Sheet1!
$C$7:$C7,$B$8:$B$15),0))in C8 is your formula for the
first cell adjacent to your column of numbers,
=INDEX($B$8:$B$15,MATCH(0,COUNTIF($C$8:$C8,$B$8:$B$15),0))
is your second formula for the second cell ajacent to your
column of numbers and this one can be dragged down to the
last entry of your column of numbers in B.

You then 'see' (sometimes seeing is of value)the list of
unique values in column C and you can do a SUM of the
range upto where #N/A starts.

HTH
Gerry