Name Manager

I will do my best to explain this clearly.

I have a workbook with 12 separate sheets (one for each month) and a final Analysis sheet. Each sheet has a table within it named to correspond to the same month and the Analysis sheet houses the results. One thing I am tracking is how many new users there are on average each month. Originally, I did not include last year's total users (I was going to track the change from February to December only), but I have since decided to add this. In order to get one simple formula to work on the Analysis page, I defined the names in Name Manager and it all worked great. Here is where my problem starts. Now that I want to refer to an additional sheet, I can no longer get this particular defined name to work.

I used =AVERAGE(February:December!B3) before with no trouble.

When I try to update the Name Manager to =AVERAGE(January:December!B3) I receive a #VALUE error. When I go to evaluate the formula, it changes to =AVERAGE(January!$A$6:$A$70:December!B3)

What am I missing? How do I get the name manager to only reference one particular cell in each sheet? If someone could please explain when mistake I am making, I would greatly appreciate it! Thank in advance!

SAMPLE Quickbooks Transaction Exports 2015.xlsx

-Rosey

SHG,

I don't quite understand. I have 3 other defined names (AveActiveUsers, Average_Exports_per_Month, and AveragePercentage) that are using January in the refer to field. Why is it only interfering with this one? Could you be a little more specific when you say a named range and how to change it back?

-Rosey

David,

My other reply disappeared. I tried this, and I am now receiving a #REF! error. Any suggestions?

-Rosey

Thank XOR LX and SDCh! It did appear to be related to table names. I worked around this by abbreviating my sheet names and keeping the tables as the full month name. The formula worked fine. Thank you all for your help!

-Rosey