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

[davey37736]

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?

[Govind]

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?

[davey37736]

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?
>

[Anne Troy]

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

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