Sum Dates
 

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.

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
__________________________

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

"Richard Buttrey" wrote:

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
__________________________

Try the pivot table approach.

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.