Dec 18 2021 02:32 AM
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.