On Thu, 29 Sep 2005 11:15:04 -0700, "riseazufall"
wrote:

I have a worksheet with multiple appearances of various dates in column "a".
In column "b" I have dollar amounts. Is there a way to write a formula that
will look up all similar dates in column "a" and add up the corresponding
values from column "b" and put them in the next column? I have about 3000
lines per worksheet, so doing the SUMIF function with ranges each time is not
conduscive.

Have you tried a pivot table?

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________