ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   add cells in several worksheets (https://www.excelbanter.com/excel-worksheet-functions/110448-add-cells-several-worksheets.html)

oxicottin

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

Don Guillett

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





All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com