Need Help with subtotals please!

[Maximiliano]

Hallo dear Forum,
could you please help me!
i have a table like that:

--ID----Money---
-1033--10000----
--------5000----
--------4500----
-1045--12000---
--------7800----
--------3000----

Now i want to add subtotals for every ID number that it looks like this:

--ID----Money---
-1033--10000----
--------5000----
--------4500----
Total---19500---
-1045--12000---
--------7800----
--------3000----
Total---22800---

Could someone tell me how i can do this. when i add subtotals it doesn't realize, that for example the 5000 belongs to the ID 1033.

Every help is very apreaciated!
Maximiliano

 

[VoG]

You need to fill in the missing values in column A. Select column A, press F5, click Special, tick Blanks, click OK.


Press=

Press Up arrow

Hold down CTRL and press Enter.

Subtotals should work now.

 

[Maximiliano]

Thanks!

Yes this does work. But is there maybe another possibility?

Like that the funktion regonizes automatically when there is a new customer and then starts a new subtotal?

 

[VoG]

Sorry, no. The Subtotals function expects all rows to be filled.

 

[mcnealfbm]

I recommend saving as values after you fill in the blank cells, before you insert the subtotals. Otherwise sometimes people will want to sort your file and it will get all messed up.

Frances

 

[Maximiliano]

Thanks for your help!!!