D
diaare
Please bear with me while I try an explain:
I have a workbook I created that has data in a summary tab (with two named
ranges: ModelName and Totals), and a second tab that has various formulas and
caluculations that use the data (and named ranges) from the summary tab.
Each week I need to update the summary tab with new data. So, I created a
"templete" (its not really saved as a templete, I just call it that) for
weekly data. I just cleared out the contents of the summary tab, checked to
make sure the named ranged were still there, and checked to make sure the
formulas in the second tab reset to zero (they did).
My goal is to be able to open my "templete"each week, save it as a different
name, paste my data in to the summary tab, and have the formulas on the
second tab automatically calculate. But, the formulas on the second tab
always show zero whether there is data in the first tab or not.
I checked my named ranges and they look the same, and I checked my formulas
on my second tab and I don't see any errors.
Here is one of them:
=SUMIF('Cond weekly sched_templete.xlt'!ModelName,"TUC-27*",'Cond weekly
sched_templete.xlt'!Totals)
Where the named range for ModelName =Summary!$L$3:$L$4000
and Totals =Summary!$O$3:$O$4000
I can't understand why it worked before but now, that I cleared out my data
in the summary tab and replace it with new data, it doesn't work.
Am I going about this the wrong way?
Thanks,
Diane
I have a workbook I created that has data in a summary tab (with two named
ranges: ModelName and Totals), and a second tab that has various formulas and
caluculations that use the data (and named ranges) from the summary tab.
Each week I need to update the summary tab with new data. So, I created a
"templete" (its not really saved as a templete, I just call it that) for
weekly data. I just cleared out the contents of the summary tab, checked to
make sure the named ranged were still there, and checked to make sure the
formulas in the second tab reset to zero (they did).
My goal is to be able to open my "templete"each week, save it as a different
name, paste my data in to the summary tab, and have the formulas on the
second tab automatically calculate. But, the formulas on the second tab
always show zero whether there is data in the first tab or not.
I checked my named ranges and they look the same, and I checked my formulas
on my second tab and I don't see any errors.
Here is one of them:
=SUMIF('Cond weekly sched_templete.xlt'!ModelName,"TUC-27*",'Cond weekly
sched_templete.xlt'!Totals)
Where the named range for ModelName =Summary!$L$3:$L$4000
and Totals =Summary!$O$3:$O$4000
I can't understand why it worked before but now, that I cleared out my data
in the summary tab and replace it with new data, it doesn't work.
Am I going about this the wrong way?
Thanks,
Diane