I would like to know if it is possible to get a sum total from two pages on a
worksheet when each page is set up with the same Title and Column headings
but with the title merged across the page. My employer does not want me to
freeze the panes for the title and column headings.

First of all......undo the merged cells you're using for the titles and change
the format to "center across selection" which works for titles and does not
create the problems merged cells will give you.

Summing two totals into one would depend upon where they are.

=A50+A100 is a starter.

BTW..........your employer is creating extra work by not using Freeze Panes, but
I guess you already knew that<g


Gord Dibben MS Excel MVP

On Sat, 2 Jun 2007 11:30:00 -0700, Muriel
wrote:

I would like to know if it is possible to get a sum total from two pages on a
worksheet when each page is set up with the same Title and Column headings
but with the title merged across the page. My employer does not want me to
freeze the panes for the title and column headings.

Hi,

If the previous answer works, fine, if not could you please show us what
your data looks like. Based on the limited description the answer would be
more like =Sheet2!A502+Sheet3!A100.

Now if the cells in both sheets are the same and the sheets are contiguous
then:

=SUM(Sheet2:Sheet3!A50) might be another solution.

But freeze panes and merged titles don't appear to be relavant to the
question as stated.
--
Cheers,
Shane Devenshire


"Muriel" wrote:

I would like to know if it is possible to get a sum total from two pages on a
worksheet when each page is set up with the same Title and Column headings
but with the title merged across the page. My employer does not want me to
freeze the panes for the title and column headings.

Two takes on one post..................how rare<g

OP states "two pages on a worksheet"

The merged titles and freeze panes makes sense if that's the case.

Row 1 is titles............row 51 is the same titles instead of freezing row 1

Might be better if OP had just one row of titles at top and used "rows to repeat
at top" when printing the two pages.

Gord

On Sat, 2 Jun 2007 13:22:00 -0700, ShaneDevenshire
wrote:

Hi,

If the previous answer works, fine, if not could you please show us what
your data looks like. Based on the limited description the answer would be
more like =Sheet2!A502+Sheet3!A100.

Now if the cells in both sheets are the same and the sheets are contiguous
then:

=SUM(Sheet2:Sheet3!A50) might be another solution.

But freeze panes and merged titles don't appear to be relavant to the
question as stated.

Thank you Gord, your answer was all I needed to take care of the problem in a
quick, easy manner.

"Gord Dibben" wrote:

Two takes on one post..................how rare<g

OP states "two pages on a worksheet"

The merged titles and freeze panes makes sense if that's the case.

Row 1 is titles............row 51 is the same titles instead of freezing row 1

Might be better if OP had just one row of titles at top and used "rows to repeat
at top" when printing the two pages.

Gord

On Sat, 2 Jun 2007 13:22:00 -0700, ShaneDevenshire
wrote:

Hi,

If the previous answer works, fine, if not could you please show us what
your data looks like. Based on the limited description the answer would be
more like =Sheet2!A502+Sheet3!A100.

Now if the cells in both sheets are the same and the sheets are contiguous
then:

=SUM(Sheet2:Sheet3!A50) might be another solution.

But freeze panes and merged titles don't appear to be relavant to the
question as stated.