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
Bookmarks