| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add cells in several worksheets
I have a excell file that has several worksheets and on each worksheet it has
several employees names and %'s. Is there some way I can have a worksheet at the end or beginging of all the others and have it total %'s from the other worksheets? Lets say I want to total a row A1 to L1 from the other worksheets and it gives me a total % from the % numbers in the rows on each worksheet. Thanks Chad |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add cells in several worksheets
start with this idea. Notice the :
=sum(firstsheet:lastsheet!a1) -- Don Guillett SalesAid Software "oxicottin" wrote in message ... I have a excell file that has several worksheets and on each worksheet it has several employees names and %'s. Is there some way I can have a worksheet at the end or beginging of all the others and have it total %'s from the other worksheets? Lets say I want to total a row A1 to L1 from the other worksheets and it gives me a total % from the % numbers in the rows on each worksheet. Thanks Chad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't consolidate non-data (ie text) cells from worksheets | Excel Worksheet Functions | |||
| How to copy multiple cells between worksheets | Excel Discussion (Misc queries) | |||
| Eliminating Blank Cells From Lists on different worksheets | Excel Discussion (Misc queries) | |||
| How do I add cells from different worksheets? | Excel Discussion (Misc queries) | |||
| How do I unlink cells in different worksheets when there are no a. | Excel Worksheet Functions | |||
Linear Mode
