Sum Multiple Worksheets, same named cell

  • Thread starter Thread starter uncreative
  • Start date Start date
U

uncreative

I have multiple worksheets containing the same named cell (e.g. Month_Total).
On a totals worksheet, I am not able to use =SUM('START,END'!Month_Total)
because of the local/global naming. Is there a way around this?
(Month_Total will not always be in the same cell on each worksheet).

Thanks!
 
It seems to me that you have two options.

1. Name each of your "Monthly Total"s slightly different.

OR

2. Do not use the cell range naming.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Sum across WORKSHEET 6
summing same cell in multiple worksheets 3
sum accross worksheets using names 1
Using Worksheet Name 3
Summing over multiple worksheets 1
Sum same cell/range of multiple worksheets within a workbook... 2
Inerting name of current worksheet into fuction 11
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top