I am a tax collector and trying to set up a work sheet on excel for
collections during the month. I will have several number columns that will
need to be totaled at the end of each page and a final total at the end of
the month. There could be as many as 50 pages each month. Is this possible?
I thought maybe I could find a template already set up? Any help would be
greatly appreciated.


Thanks

This is very possible. One of the things that Excel excels at, as a matter
of fact.

On the individual sheets you can put this formula after the last entry in a
column
=SUM(A1:A99)
this assumes the column to be added is column A and that the numbers to be
added together are in rows 1 through 99. If your columns on that sheet are
of equal length, you can then just select that formula and drag it across the
rest of the columns and it will adjust itself automatically to provide the
sum of each column.

It is also possible to add up totals of cells on several different sheets.
Probably the easiest way to tell you how to do it as a beginner is actually
more labor intensive than a possible faster way. But this works no matter
how each sheet is laid out.

Choose a cell on a sheet to hold the sum of cells from other sheets, start a
formula in that cell by simply typing an equal symbol
=
then choose the first sheet with a cell to be added as a group and click on
that cell, then enter the + symbol and choose next sheet/next cell to be
added up on the first sheet. Repeat until you've chosen the last sheet and
cell to be added into the one cell and press the [Enter] key. Again, repeat
for as many groups as you need to sum this way.

IF your 50 pages are laid out the same way, with matching values falling
into the same cells on all pages, there is a quick way to sum the values in a
given cell on all of the sheets. Picture this as stacking the sheets neatly
and punching a hole through all of them:

Lets assume that all 50 sheets have a total of a column that needs to be
"rolled up" into a total for all sheets, and that the column total is in cell
B100 on each of the 50 sheets.

You could choose a cell on a sheet (it can be any cell on any sheet) and
then again start a formula by typing the = symbol. Because we want to add
ranges, we can again use the SUM function, so type in SUM(. At this point
the formula in the cell would look like
=SUM(
click on the first sheet in the group of 50 sheets, scroll so that you can
see the last sheet in the group of 50 sheets and while holding down the
[Shift] key, click the tab for that sheet. This should select all 50 sheets
as a group. Then just click on cell B100 on the sheet that is visible. Type
in a closing parenthesis symbol { ) } and hit the [Enter] key.

The formula on your sheet should now look something like:
=SUM(Sheet1:Sheet50!B100)

Hope this helps some.

"KC" wrote:

I am a tax collector and trying to set up a work sheet on excel for
collections during the month. I will have several number columns that will
need to be totaled at the end of each page and a final total at the end of
the month. There could be as many as 50 pages each month. Is this possible?
I thought maybe I could find a template already set up? Any help would be
greatly appreciated.


Thanks

Is it necessary to teach a tax collector how to tally tax?

"JLatham" wrote in message
...
This is very possible. One of the things that Excel excels at, as a
matter
of fact.

On the individual sheets you can put this formula after the last entry in
a
column
=SUM(A1:A99)
this assumes the column to be added is column A and that the numbers to be
added together are in rows 1 through 99. If your columns on that sheet
are
of equal length, you can then just select that formula and drag it across
the
rest of the columns and it will adjust itself automatically to provide the
sum of each column.

It is also possible to add up totals of cells on several different sheets.
Probably the easiest way to tell you how to do it as a beginner is
actually
more labor intensive than a possible faster way. But this works no matter
how each sheet is laid out.

Choose a cell on a sheet to hold the sum of cells from other sheets, start
a
formula in that cell by simply typing an equal symbol
=
then choose the first sheet with a cell to be added as a group and click
on
that cell, then enter the + symbol and choose next sheet/next cell to be
added up on the first sheet. Repeat until you've chosen the last sheet
and
cell to be added into the one cell and press the [Enter] key. Again,
repeat
for as many groups as you need to sum this way.

IF your 50 pages are laid out the same way, with matching values falling
into the same cells on all pages, there is a quick way to sum the values
in a
given cell on all of the sheets. Picture this as stacking the sheets
neatly
and punching a hole through all of them:

Lets assume that all 50 sheets have a total of a column that needs to be
"rolled up" into a total for all sheets, and that the column total is in
cell
B100 on each of the 50 sheets.

You could choose a cell on a sheet (it can be any cell on any sheet) and
then again start a formula by typing the = symbol. Because we want to add
ranges, we can again use the SUM function, so type in SUM(. At this point
the formula in the cell would look like
=SUM(
click on the first sheet in the group of 50 sheets, scroll so that you can
see the last sheet in the group of 50 sheets and while holding down the
[Shift] key, click the tab for that sheet. This should select all 50
sheets
as a group. Then just click on cell B100 on the sheet that is visible.
Type
in a closing parenthesis symbol { ) } and hit the [Enter] key.

The formula on your sheet should now look something like:
=SUM(Sheet1:Sheet50!B100)

Hope this helps some.

"KC" wrote:

I am a tax collector and trying to set up a work sheet on excel for
collections during the month. I will have several number columns that
will
need to be totaled at the end of each page and a final total at the end
of
the month. There could be as many as 50 pages each month. Is this
possible?
I thought maybe I could find a template already set up? Any help would
be
greatly appreciated.


Thanks

I am certain that it is NOT necessary to teach a tax collector how to tally
tax. I am equally certain that it may be necessary to provide details to a
novice at the TOOL being used in this case. Considering that it was his
request - I could have just left the answer as a simple "Yes, it can be done"
and let him figure it out on his own somehow or other.

"PY & Associates" wrote:

Is it necessary to teach a tax collector how to tally tax?

"JLatham" wrote in message
...
This is very possible. One of the things that Excel excels at, as a
matter
of fact.

On the individual sheets you can put this formula after the last entry in
a
column
=SUM(A1:A99)
this assumes the column to be added is column A and that the numbers to be
added together are in rows 1 through 99. If your columns on that sheet
are
of equal length, you can then just select that formula and drag it across
the
rest of the columns and it will adjust itself automatically to provide the
sum of each column.

It is also possible to add up totals of cells on several different sheets.
Probably the easiest way to tell you how to do it as a beginner is
actually
more labor intensive than a possible faster way. But this works no matter
how each sheet is laid out.

Choose a cell on a sheet to hold the sum of cells from other sheets, start
a
formula in that cell by simply typing an equal symbol
=
then choose the first sheet with a cell to be added as a group and click
on
that cell, then enter the + symbol and choose next sheet/next cell to be
added up on the first sheet. Repeat until you've chosen the last sheet
and
cell to be added into the one cell and press the [Enter] key. Again,
repeat
for as many groups as you need to sum this way.

IF your 50 pages are laid out the same way, with matching values falling
into the same cells on all pages, there is a quick way to sum the values
in a
given cell on all of the sheets. Picture this as stacking the sheets
neatly
and punching a hole through all of them:

Lets assume that all 50 sheets have a total of a column that needs to be
"rolled up" into a total for all sheets, and that the column total is in
cell
B100 on each of the 50 sheets.

You could choose a cell on a sheet (it can be any cell on any sheet) and
then again start a formula by typing the = symbol. Because we want to add
ranges, we can again use the SUM function, so type in SUM(. At this point
the formula in the cell would look like
=SUM(
click on the first sheet in the group of 50 sheets, scroll so that you can
see the last sheet in the group of 50 sheets and while holding down the
[Shift] key, click the tab for that sheet. This should select all 50
sheets
as a group. Then just click on cell B100 on the sheet that is visible.
Type
in a closing parenthesis symbol { ) } and hit the [Enter] key.

The formula on your sheet should now look something like:
=SUM(Sheet1:Sheet50!B100)

Hope this helps some.

"KC" wrote:

I am a tax collector and trying to set up a work sheet on excel for
collections during the month. I will have several number columns that
will
need to be totaled at the end of each page and a final total at the end
of
the month. There could be as many as 50 pages each month. Is this
possible?
I thought maybe I could find a template already set up? Any help would
be
greatly appreciated.


Thanks