LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tosh105
 
Posts: n/a
Default How to calculate percentage acroos sheets in a workbook

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending sheets in workbook billy2willy Excel Discussion (Misc queries) 4 July 28th 05 05:43 PM
In Excel, how do I print the workbook sheets to 2sided paper? workfirst Excel Discussion (Misc queries) 6 July 19th 05 08:33 PM
How do I set up a workbook so changing Sheet1 changes all sheets? rach1027 Excel Worksheet Functions 1 June 7th 05 10:12 AM
How can I delete similar rows in excel workbook with many sheets? JSchrader Excel Worksheet Functions 1 April 26th 05 06:40 PM
Updating sheets within a workbook Mike R Excel Discussion (Misc queries) 1 December 4th 04 05:25 AM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"