ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   in excel how do you total 1 cell on 25 different tabs? (https://www.excelbanter.com/excel-discussion-misc-queries/179143-excel-how-do-you-total-1-cell-25-different-tabs.html)

Neal

in excel how do you total 1 cell on 25 different tabs?
 
in excel how do you total 1 cell on 25 different tabs?

Ron de Bruin

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?


John Bundy

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