Forum Discussion
Dynamic Named Range Failure
Trisa58 , no problem.
In test file in the formula you started range from A8, actually it's from A1. In main file you have the cell with empty string below your months, thus COUNTA returned incorrect result. Since we have only twelve months in the year I'd recommend to limit the range accordingly, not use A:A. Finally the formula is
=OFFSET(SUMMARY!$A$2,0,0,COUNTA(SUMMARY!$A$1:$A$13)-1,1)
I corrected in both files. Please be carefull with relative and absolute references, here all are to be absolute.
Trisa58 ,
In general it works
Most probably you need to change second parameter in OFFSET on zero and don't deduct 1 from COUNTA. Last parameter is not required here.
I will upload, you take your time. I really appreciate any and all help you can give.
Trisa58 , no problem.
In test file in the formula you started range from A8, actually it's from A1. In main file you have the cell with empty string below your months, thus COUNTA returned incorrect result. Since we have only twelve months in the year I'd recommend to limit the range accordingly, not use A:A. Finally the formula is
=OFFSET(SUMMARY!$A$2,0,0,COUNTA(SUMMARY!$A$1:$A$13)-1,1)
I corrected in both files. Please be carefull with relative and absolute references, here all are to be absolute.