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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"loook" wrote in message
...
Hi, how can I sum unique values within a range where some cells are
blank?
An example:
A
1 100
2 150
3
4 150
5 50
6
7 100
8 100
9 50
10 SUM = 300 (100 + 150 + 50)

Thanx for any suggestion.

look