Grouping and Adding at the same time in EXCEL2000

  paulrhardy21 13:30 11 Aug 2004
Locked

I have a big problem,

I am currently trying to manipulate an excel spreadsheet.

The problem is A company has sent in payments for 5 months all in one go. And rather than give us a schedule with the total amount that each person is paying, they have split the payments into their five months.

For Example:

Mr. John Smith 00001 £100.00
Mr. John Smith 00001 £100.00
Mr. John Smith 00001 £100.00
Mr. John Smith 00001 £100.00
Mr. John Smith 00001 £100.00
Mr. Paul Brown 00002 £150.00
Mr. Paul Brown 00002 £150.00
Mr. Paul Brown 00002 £150.00
Mr. Paul Brown 00002 £150.00
Mr. Paul Brown 00002 £150.00

Those are just example names and don't represent anybody in my list.

The problem is I need to get the spreadsheet so that it looks like this

Mr. John Smith 00001 £500.00
Mr. Paul Brown 00002 £750.00

There are currently 2500 names on my list. And this has created over 10,000 items.

I have tried the Subtotals Function, which adds the totals up for me, but does not put the Name etc on the line when I collapse the list.

anybody's help would be most welcome

Thanks

Paul

  rogertjj 13:50 11 Aug 2004

How many columns of data do you have ?? If you sort the data by Name, and then perform a subtotal that Adds the value after each change in name, the collapsed list should show something like :


Mr John Smith Total £500.00

Mr Paul Brown Total £750.00


What version of Excel are you using ?

  rogertjj 13:55 11 Aug 2004

OK, brain not engaged today !! I will read the title of the post next time before asking a stupid question !!


However, Subtotals should do exactly what you need

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Les meilleures tablettes 2017