For clarification on this problem let me add that the cell location is not
the same on each sheet, but the name is the same. Although I would enjoy the
challenge I don't have the time to pick up the necessary skills to program
this - I'm hoping that there is a way to put a formula together that will
simply sum all cells with the defined name "Total" from each sheet.

"Bob Bridges" wrote:

Whew! Someone else may know another way - are lots of things you can do with
Excel that I've never heard of yet - but this sounds to me like a call for
you to write your own worksheet function in VBA, if you're willing to take
that on. It's not that hard, but if you've never done any programming it
does require learning a new skill. Or do you already know how?

--- "Sum problem" wrote:
I would like to sum a common cell, by defined name, accross a set of
different sheet. The cell name is the same, with a scope to the sheet only.
Example: sheet1!total + sheet2!total + sheet3!total... and so on
I want to be able to do this without having to type in the above, but have
been unable to determine how to get something like the following to work:
Example: =sum(sheet1!:sheet2!,total)
I would be most grateful if anyone can show me how to do this. Thanks.