in excel how do you total 1 cell on 25 different tabs?
in excel how do you total 1 cell on 25 different tabs?
|
in excel how do you total 1 cell on 25 different tabs?
Hi Neal
See http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "neal" wrote in message ... in excel how do you total 1 cell on 25 different tabs? |
in excel how do you total 1 cell on 25 different tabs?
If the data is in the same cell on every sheet, then where you want the total
type =sum( then shift and click the last sheet, this will select on in that range, then click the cell that contains the data, then add a ) and hit enter. -- -John Please rate when your question is answered to help us and others know what is helpful. "neal" wrote: in excel how do you total 1 cell on 25 different tabs? |
All times are GMT +1. The time now is 08:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com