| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate percentage acroos sheets in a workbook
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending sheets in workbook | Excel Discussion (Misc queries) | |||
| In Excel, how do I print the workbook sheets to 2sided paper? | Excel Discussion (Misc queries) | |||
| How do I set up a workbook so changing Sheet1 changes all sheets? | Excel Worksheet Functions | |||
| How can I delete similar rows in excel workbook with many sheets? | Excel Worksheet Functions | |||
| Updating sheets within a workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
