Sum at end of page

tex90 · May 13th, 2002, 10:46 AM

How can I print the sum of a column at the end of a printed page for just these lines, which have space on the printed page? And can I also print a total sum of all pages at the last page ? Thanks for help.

Corticus · May 13th, 2002, 10:57 AM

do you have some cell references?

You need to use Sum() and an array sum most likely, but more info would help...

Corticus

tex90 · May 13th, 2002, 11:12 AM

Hi Corticus,
Let me explain:
I have a list with about 500 values, but the exact number will differ all the time. I have to make printouts of this list and need the sum of the values on each page (only for the lines which are printed on this page). This sum should be printed on the bottom of the page and on the last page there should be printed also the total sum over all pages. i hope this makes it a little bit clearer.

tex90

Corticus · May 13th, 2002, 11:23 AM

since Excel gives you predictable page breaks,
go to page break view
see how many line are on a page,
put a sum at the bottom(offset from the data row) of each page, and as data is entered, these sums will apply and be printed,
for a grand total:
=SUM(Sheet1:Sheet10!B1:B500)
should do it, since your subtotals are offset,
HTH
-Corticus

tex90 · May 13th, 2002, 11:33 AM

Hi Corticus
Thanks for help. It's not exact the way I wanted to do it (I wanted to have something "automatic"), but it helps at the moment. I will think about, if it's possible to do this with a macro.
Best greetings from Vienna
Tex

Abcd · May 13th, 2002, 02:28 PM

This has been covered before.
Do a search for "printing sub totals on each page" (search for all items) and you will find the thread.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 10:46 AM	#1
tex90 New Member Join Date: May 2002 Location: Vienna / Austria Posts: 3	How can I print the sum of a column at the end of a printed page for just these lines, which have space on the printed page? And can I also print a total sum of all pages at the last page ? Thanks for help.

May 13th, 2002, 10:57 AM	#2
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	do you have some cell references? You need to use Sum() and an array sum most likely, but more info would help... Corticus

May 13th, 2002, 11:12 AM	#3
tex90 New Member Join Date: May 2002 Location: Vienna / Austria Posts: 3	Hi Corticus, Let me explain: I have a list with about 500 values, but the exact number will differ all the time. I have to make printouts of this list and need the sum of the values on each page (only for the lines which are printed on this page). This sum should be printed on the bottom of the page and on the last page there should be printed also the total sum over all pages. i hope this makes it a little bit clearer. tex90

May 13th, 2002, 11:23 AM	#4
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	since Excel gives you predictable page breaks, go to page break view see how many line are on a page, put a sum at the bottom(offset from the data row) of each page, and as data is entered, these sums will apply and be printed, for a grand total: =SUM(Sheet1:Sheet10!B1:B500) should do it, since your subtotals are offset, HTH -Corticus

May 13th, 2002, 11:33 AM	#5
tex90 New Member Join Date: May 2002 Location: Vienna / Austria Posts: 3	Hi Corticus Thanks for help. It's not exact the way I wanted to do it (I wanted to have something "automatic"), but it helps at the moment. I will think about, if it's possible to do this with a macro. Best greetings from Vienna Tex

May 13th, 2002, 02:28 PM	#6
Abcd New Member Join Date: Mar 2002 Posts: 7	This has been covered before. Do a search for "printing sub totals on each page" (search for all items) and you will find the thread.