If the values are in the same cell across all worksheets you can group your
worksheets by clicking on the sheet 1 and shift + Click on sheet 58. And use
something like the formula below to calc your average.

=SUM(Sheet1:Sheet58!A1)/58
--
Kevin Backmann


"tosh105" wrote:

I have 58 sheets in a workbook, and I need to calculate the percentage across
all sheets into sheet 1. We are using this workbook to conduct a training
analysis. Each sheet represents a learner, and their knowledge of the
content as high medium or low. Sheet 1 should give us an overview of the
specs, yet it seems excel 2000 cuts you off after 35 sheets when writing the
formula