Sum Dates

[Guest]

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.

 

[Richard Buttrey]

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
__________________________

 

[Guest]

I'm not that experienced in Pivot Tables, however with some direction, I
could possibly figure it out? Thank you for your response!

 

[Aladin Akyurek]

Try the pivot table approach.