Posted to microsoft.public.excel.programming

external usenet poster

Posts: 13

Count totals for the same accounts

Hi all,
I'm new in VBA.
Could anyone helps me with vba code in excel to count totals? I have
two columns:

Account Amount
19216801 5
19216803 10
19216808 2
19216801 3
19216801 5
19216803 6
19216801 34
19216801 21
19216808 45

I'd like to see them like this:
Account Amount
19216801 68
19216803 16
19216808 47

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count subset-totals in column	Pluggie	Excel Worksheet Functions	4	February 3rd 09 05:36 PM
Excel 2000, count, sort a list & count totals?	sunslight	Excel Worksheet Functions	1	April 9th 07 05:46 PM
Using AND + COUNTIF to filter / count totals	ClintG	Excel Discussion (Misc queries)	4	January 23rd 07 04:16 PM
pivot table question about count and totals	Vabu3184	Excel Discussion (Misc queries)	1	May 22nd 06 06:10 AM
count of totals for pivot table	SteveM	Excel Discussion (Misc queries)	3	September 14th 05 01:56 PM

All times are GMT +1. The time now is 08:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us