count formula between worksheets

S

Seti

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.
 
C

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
 
P

Peo Sjoblom

count

=COUNT(Sheet2:Sheet90!A1)

sum

=SUM(Sheet2:Sheet90!A1)


Regards,

Peo Sjoblom
 
Top