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