Forum Discussion
Julian Chen
Dec 18, 2021Brass Contributor
Dynamic reference in a 3-D formula
I have a 3-D formula as shown below
SUM("Sheet1:Sheet5!"F351)
I tried to assemble the reference F351 as something like "F"&TODAY()-44195, and have Excel treat it as a reference dynamically. Please help me to rewrite the above formula to make it workable. Thanks.
No RepliesBe the first to reply