How to make Dynamic range (width) with OFFset function

[Charles]

Hi,

Yes you can, but if you are constantly updating the info why not just use the formula supplied by Rajan_Verma

if you fill the cells not continously
=SUM(C2:INDEX(C2:T2,1,MATCH(999999999,C2:T2,1)))

[Kevin@Radstock]

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

[Rajesh Kr Joshi]

Thanks guys.