Hi

I have two columns in excel, col A and col B.What I would want to achieve is following:

Col A Col B
A 2
A 2
A 2
B 3
B 3
B 3
B 3
C 3
C 3
C 3

Now I want a total of values in column B pertaining to unique (or say 1st occurences) of values in Col A. So in this case the output should be 8 ,Achieved as follows(2 +3+3).

I have already tried the solution in the following forum http://www.ozgrid.com/forum/showthread.php?t=59420 but it does not work.

Hope I have made myself clear.Request someone to help.