ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding cells witht the same name (https://www.excelbanter.com/excel-discussion-misc-queries/103849-adding-cells-witht-same-name.html)

redmondmak

Adding cells witht the same name
 
Let's say I have a cell named, "Total" and I copy the sheet. Now I have two
cells that have the name "Total". Each time a copy over I get more cells with
the same name "Total".

Thats fine by me, but I want to know if there is a formula that will sum up
all the sheets with the same name, "Total"? This way if I delete a sheet the
formula will update the sum of all the remaing cells named "Total".

It seems like an easy question but I'm not sure how to do it. Any sugestions?


All times are GMT +1. The time now is 07:02 PM.

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