Is there a way to do this........

[cajun34]

I have investment spreadsheet that has 12 pages to it. Each sheet has totals on it. Is there a way to have grand totals of all the sheets on the first page?

cajun

[Ian Mac]

On 2002-05-23 08:58, cajun34 wrote:
I have investment spreadsheet that has 12 pages to it. Each sheet has totals on it. Is there a way to have grand totals of all the sheets on the first page?

cajun

Is the layout of each sheet Exactly the same?

[Mark W.]

See the Excel Help topic for "Consolidate data".

[cajun34]

Yes, the layout for every sheet is the same.


Regards,

cajun

[Ian Mac]

On 2002-05-23 09:12, cajun34 wrote:
Yes, the layout for every sheet is the same.


Regards,

cajun

I that case you can just use =SUM()

first put =SUM(
then click on the cell you want to to Add

then with the Shift Key held down select the last Sheet you want.

this should give you what you need.

e.g. =SUM(Sheet1:Sheet12!A1)

Hope this helps.

Also look into Mark's suggestion.

[cajun34]

Ian,

I'm lost. Any chance I can send you the spreadsheet?

Regards,

cajun

[Ian Mac]

On 2002-05-23 09:45, cajun34 wrote:
Ian,

I'm lost. Any chance I can send you the spreadsheet?

Regards,

cajun

by all means, BUT I won't pick it up til tomorrow though. Unfortunately I'm finishing work now (17:48 GMT). But ask any questions you have to board and I'm sure they'll get answered.

[cajun34]

Ian,

I have sent you an email. (You sent me the wrong file)

Regards,

cajun