software

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?

Hi,

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

=SUM(Firstsheet:Lastsheet!A2)

Regards

Govind.

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

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

quot;Govindquot; wrote:

gt; Hi,
gt;
gt; If all the sheets are of the same format, then use
gt;
gt; =SUM(Firstsheet:Lastsheet!A2)
gt;
gt; Regards
gt;
gt; Govind.
gt;
gt; davey37736 wrote:
gt; gt; I have 7 different pages that i am using for a daily contest. I would like
gt; gt; the last sheet to be a running total for all of the pages, how do i do these
gt; gt; formulas?
gt;

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

quot;davey37736quot; gt; wrote in message
...
gt;I still cant seem to get it to work and i am not sure why........
gt;
gt; quot;Govindquot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; If all the sheets are of the same format, then use
gt;gt;
gt;gt; =SUM(Firstsheet:Lastsheet!A2)
gt;gt;
gt;gt; Regards
gt;gt;
gt;gt; Govind.
gt;gt;
gt;gt; davey37736 wrote:
gt;gt; gt; I have 7 different pages that i am using for a daily contest. I would
gt;gt; gt; like
gt;gt; gt; the last sheet to be a running total for all of the pages, how do i do
gt;gt; gt; these
gt;gt; gt; formulas?
gt;gt;