View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
redmondmak redmondmak is offline
external usenet poster
 
Posts: 1
Default 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?