sum dynamic range of cells in the same row

[ofer35]

hi,
In A4 i want to sum dynamic number of columns, start from B4 to the right.
e.g: B4:E4
e.g: B4:K4
i tried: =SUM(OFFSET($B$4,0,0,3,COUNTA(4:4)))
but the formula works in every ceII except A4.
1) why ?
2) Greatful for correct formula.
ofer

 

[ofer35]

"but the formula works in every ceII except A4" ------> i wrote by mistake A4 and i mean B4

 

[DHayes]

Hi,
If I understand you correctly you have created a circular reference. In other words you can't calculate the same cell in the formula where the formula is written.

 

[Canapone]

Hi,

the segment

COUNTA(4:4)

creates a circular reference on row 4

you could try instead something like:

COUNTA(B4:Z4)

Regards

Edit: Hi Dhayes. Sorry: I did not mean to overlap...

 

[Aladin Akyurek]

In A4 enter:

=SUM(B4:INDEX(B4:XFD4,MATCH(9.99999999999999E+307,B4:XFD4)))