excel 2010 - Is it possible to have a defined name that applies multiple cells via relative reference? -
i have cell numerous relative references pointing span multiple sheets; possible define name original cell , have apply of other linked cells dynamically? defined name need changed often. need format of aforementioned cells dynamically hoping use name refer of them in formula. using vba isn't option in situation.
a defined name can refer to, example:
=offset(sheet1!c1,,-2)+offset(sheet2!c1,,-2)+offset(sheet3!c1,,-2)
placed in c1 of sheet4 should sum whatever in a1 across sheets1 - 3 both inclusive , a2 across sheets1 - 3 both inclusive if dragged down 1 cell, , forth.
Comments
Post a Comment