Hello all - this is my first post. I have a similar problem, but...
what if one does not know the total number of references?
i.e.
A B
7 2.096
7 2.351
7 1.741
19 1.645
7 11.843
7 4.227
4 3.266
11 3.376
4 1.972
11 1.729

but I do not know how many unique column A refereces there are - there
could be 10 unique numbers or 3, but I want a total of the value for
each unique number within a range.
thanks a lot!
Scott


--
Suggy
------------------------------------------------------------------------
Suggy's Profile: http://www.excelforum.com/member.php...o&userid=28877
View this thread: http://www.excelforum.com/showthread...hreadid=483964