totaling purchases

C

CookinGuy

Hi

I want to take a list of purchases (not necessarily in chronological order) and have Excel 2000 total each days' purchases and put that in another cell. Example-

6/1 $1
6/5 $3
6/1 $2
6/4 $7
6/3 $6
6/1 $3

will give me this-
6/1 $6
6/2 -
6/3 $6
6/4 $7
6/5 $3

Currently, I am doing it all myself. This is kind of a pain. I know it can be done but I can't figure out how.
Thanks
 
N

Norman Harker

Hi CookinGuy!

Take a look at answers to your first post.

Posts usually take several minutes to appear and may take a lot longer
if you link to newsgroups other than through msnews.microsoft.com.
 
M

mark E. Philpot

Gidday,

I have written a macro that does just what you ask. It is
called rowmultiples.xls and you can find it at:
http://au.geocities.com/excelmarksway

regards
Mark
-----Original Message-----
Hi

I want to take a list of purchases (not necessarily in
Click to expand...
chronological order) and have Excel 2000 total each days'
purchases and put that in another cell. Example-
6/1 $1
6/5 $3
6/1 $2
6/4 $7
6/3 $6
6/1 $3

will give me this-
6/1 $6
6/2 -
6/3 $6
6/4 $7
6/5 $3

Currently, I am doing it all myself. This is kind of a
Click to expand...
pain. I know it can be done but I can't figure out how.
 
Top