Hi all,
i need a help to to sum merge cell values with this formula =SUM(OFFSET(INDEX($B$2:$B$19,MATCH(F2,$B$2:$B$19,0)),0,2,4,1)). i want to calculate height AUTO in OFFSET rather than put manually.
File is attached. i use a formula in column G.
Thanks.
Bookmarks