Put the sheet names in an array C1:C70

=SUMPRODUCT(N(INDIRECT("'"&C1:C70&"'!A1")))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PACable" wrote in message
...
I have to add onto this formula which is all ready too long
I need to get the sum of 70 worksheets