Hi
My first post!
Another version for a formula approach in B2:
=SUM(OFFSET($B2,0,1,1,LOOKUP(2,1/$C2:$T2,$C2:$T2))) and copy down.
Also accounts for cells not filled in continuously.
Kevin
Hi
My first post!
Another version for a formula approach in B2:
=SUM(OFFSET($B2,0,1,1,LOOKUP(2,1/$C2:$T2,$C2:$T2))) and copy down.
Also accounts for cells not filled in continuously.
Kevin
Posting Permissions
Reply With Quote
Bookmarks