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?
|