Function for add different values

[douglasracaixeta]

I need one function that adds values that are not equal.

Like this:
3
3
3
4
4
5
5

I need a formula that will go to add value 3+4+5.
Only different numbers between itself.
Which are my options?

 

[Peo Sjoblom]

Please refrain from multiposting, you got at least one answer already in the
worksheet functions ng

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com