How can I subtotal in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the Subtotal function how do I subtotal by page break? My spreadsheet
is 3800 rows and I need a subtotal at the bottom each page.
 
The wizard does not allow for subtotal after each page break. Here an
example of the data I need a subtotal at the end of each page in the column
titled Amount.


ID SSN First Name Last Name
Amount
100 ???-??-???? SAM WALKS OUT 5,000.00
101 ???-??-???? MIKE CLIFFORD 4,500.94
165 ???-??-???? JOHN BEAR 1,000.00
107 ???-??-???? MONIQUE MOUSSE 500.00
 
Check the Page Break option. It appears at the beginning
of the wizard.
-----Original Message-----



The wizard does not allow for subtotal after each page break. Here an
example of the data I need a subtotal at the end of each page in the column
titled Amount.


ID SSN First Name Last Name
Amount
100 ???-??-???? SAM WALKS
Click to expand...
OUT 5,000.00
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Subtotaling 3
Additonal info into newly created Subtotal row 1
subtotal, match? 10
Subtotal of adjacent coloumn 4
How do I subtotal specific / random rows from a spreadsheet? 1
ON SUBTOTAL LINE CARRY FORWARD DENOMINATOR FROM PREVIOUS LINE 1
Subtotal function is greyed-out - can't insert 3

Back
Top