![]() |
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 |
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