Dynamic reference in a 3-D formula

Brass Contributor

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.

0 Replies