how do i total up different pages all on one page?
 

I have 7 different pages that i am using for a daily contest. I would like
the last sheet to be a running total for all of the pages, how do i do these
formulas?

how do i total up different pages all on one page?
 

Hi,

If all the sheets are of the same format, then use

=SUM(Firstsheet:Lastsheet!A2)

Regards

Govind.

davey37736 wrote:
I have 7 different pages that i am using for a daily contest. I would like
the last sheet to be a running total for all of the pages, how do i do these
formulas?

how do i total up different pages all on one page?
 

I still cant seem to get it to work and i am not sure why........

"Govind" wrote:

Hi,

If all the sheets are of the same format, then use

=SUM(Firstsheet:Lastsheet!A2)

Regards

Govind.

davey37736 wrote:
I have 7 different pages that i am using for a daily contest. I would like
the last sheet to be a running total for all of the pages, how do i do these
formulas?

how do i total up different pages all on one page?
 

Davey: Your workbook must be set up "just so". See the complete instructions
of what Govind suggests he
http://www.officearticles.com/excel/...rk sheets.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"davey37736" wrote in message
...
I still cant seem to get it to work and i am not sure why........

"Govind" wrote:

Hi,

If all the sheets are of the same format, then use

=SUM(Firstsheet:Lastsheet!A2)

Regards

Govind.

davey37736 wrote:
I have 7 different pages that i am using for a daily contest. I would
like
the last sheet to be a running total for all of the pages, how do i do
these
formulas?