Novice needs help setting up a worksheet

[KC]

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

[JLatham]

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

[PY & Associates]

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

"JLatham" <[email protected]> wrote in message
news:[email protected]...
> 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

[JLatham]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>