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.