Grouping and Adding at the same time in EXCEL2000

  paulrhardy21 13:30 11 Aug 04
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 04

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 04

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.

What is Google Allo? What is Google Duo? Google Allo UK release date and features: Google Allo is…

1995-2015: How technology has changed the world in 20 years

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…