Sum Offset Formula Help

[Puppies72]

Hi all,

Struggling wth the correct formula here.

In A4 I need a sum offset formula

In B4 I have the number of columns I want totalled (sum)

In C4-DQ4 I have my values

I have tried the formula below in A4 but it doesn't seem to be giving me the right totals - I suspect it is the format of the offset argument that is wrong

=IF(B4="","",SUM($B$4,OFFSET($B$4,0,0,B4,1)))

Any help as always greatly appreciated

 

[JoeMo]

Try

=IF(B4="","",SUM(OFFSET(C4,0,0,1,B4)))

 

[Puppies72]

Great stuff - fiddly little thing was driving me mental - thank you so much!

 

[mancemonster]

Nearly there...

tweeking the formula you had slightly..

=IF(B4="","",SUM($B$4,OFFSET($B$4,0,0,1,B4)))

Do you intend to include B4 in the sum?

if not...

=IF(B4="","",SUM($C$4,OFFSET($C$4,0,0,1,B4)))

Regards


Roger