Sum some how!

[Jeane]

I have three columns of information. In the first are account numbers, the second is an individual identifier and in the last the charge for each person


12345 James Jones $15
12345 Elaine Smith $12.50
23456 Will Johnson $15
23456 Andy Wilson $94.50

What I need to do is total the amounts for the account numbers so account number 12345 totals 27.50 for instance. In column A there is about 300 account numbers but 7000+ entries because there are many individuals on each account number, each on its own line, but not a specific number on each account. 12345 has 15 entries, but 23456 may have 90. Next week that could be switched or one of them may not be listed at all.

This report took the previous person about 4 hours to complete. I would like to write up a macro (most of it easy enough) so that I can do it in an hour Some things just can't be done with a macro, but no worries there!

Thanks for your help!!

[DonkeyOte]

a tip for you... highlight your range in 1st column (first row to last or whole column if nothing else in it other than ACs and blanks) -- now:

Edit -> GoTo -> Special -> Select Blanks -> now type = then use up arrow to reference the above cell --> hold CTRL and press ENTER

You will now find all blanks are populated with the appropriate ID.

Once you've done the above you can do what you want do very easily using a Pivot Table or just using Standard SUMIF function.

[shg]

Jeane,

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.