count formula between worksheets

[Guest]

I am creating a massive workbook with roughly 90 worksheets. I need a
formula to count all the numbers in one cell for all 90 sheets and total it
in one cell. Any ideas, I'm fairly new at this.

 

[Harald Staff]

=SUM(Sheet2:Sheet90!A1)

HTH. Best wishes Harald

 

[Chip Pearson]

Try a 3D formula like the following:

=SUM(Sheet1:Sheet90!A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

count

=COUNT(Sheet2:Sheet90!A1)

sum

=SUM(Sheet2:Sheet90!A1)


Regards,

Peo Sjoblom