Page Subtotals

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

Guest

Here is the situation that I am requesting assistance with

I have a multi-page spreadsheet that I have been asked to add subtotals to at the bottom of each page. This is not adding page breaks after subtotals but adding subtotals because there are page breaks. Column headers include vendor, document number, cost, retail and so forth. The subtotal should be the sum of the retail on each page and may appear in an additional column. My intent is for excel to calculate these subtotals instead of me going and adding the sum function at the bottom of every page. Any ideas of how I can do this

Any assistance you can provide will be GREATLY appreciated…..Thanks
 
It depends on whether the retail figures always lie in the
same place relative to the subtotal cell, if they don't
you may have juggle things a bit...
If they do then one possible way of doing it is

Let x= the number of rows you have per page
Let n= the row on each page where you want the subtotal to
appear

In a new column e.g. P
In P1 type =IF(MOD(ROW(),x)=n,"",ROW())

i.e if there are 53 lines per page and you want the total
on line 51 then
=IF(MOD(ROW(),53)=51,"",ROW())

fill down to the end of all the pages

Select this column and filter it for blanks
(Data menu, Filter, Autofilter - then select (Blanks) from
the list)
You can then type your subtotal formula in the first
appropriate cell and then fill down to the last one.

After you're sure everything's worked okay you can delete
the column you created.

Hope this helps




-----Original Message-----
Here is the situation that I am requesting assistance with:

I have a multi-page spreadsheet that I have been asked to
Click to expand...
add subtotals to at the bottom of each page. This is not
adding page breaks after subtotals but adding subtotals
because there are page breaks. Column headers include
vendor, document number, cost, retail and so forth. The
subtotal should be the sum of the retail on each page and
may appear in an additional column. My intent is for
excel to calculate these subtotals instead of me going and
adding the sum function at the bottom of every page. Any
ideas of how I can do this?
 
Back
Top