sum contents in rows without setting an explicit last cell index

[niksirat2030]

hi every one.

how can sum contents in rows from starting cell on left (Sheet Right-to-Left) without setting an explicit last cell index?

in attachment file, games are adding everyday, i want sum total score for all user in column "total score"

[Olly]

In E7, enter:

Please Login or Register  to view this content.

and copy down.

[niksirat2030]

In E7, enter:

Please Login or Register  to view this content.

and copy down.

thanks you, but this answer is right when table contain header in row 6. i mean if i clear "game1", "game2", ... your formula return #REF!

[Olly]

Yes - it works for the worksheet structure you showed.

If you have a different worksheet structure you want it to work with, then show us that instead?

[niksirat2030]

Yes - it works for the worksheet structure you showed.

If you have a different worksheet structure you want it to work with, then show us that instead?

i want a formula don't depends on any cell value just first cell like F7 in this example.

thanks.

[Olly]

With no dependencies to calculate the size of the sum range, then you can simply use:

Please Login or Register  to view this content.

[niksirat2030]

With no dependencies to calculate the size of the sum range, then you can simply use:

Please Login or Register  to view this content.

i mean a formula that find number of last column in specified row (like row 7) that contain a number and write that formula instead ........ in formula SUM(OFFSET($F7,0,0,1,.........)).

Is necessary such a formula i explain or i use your formula (=SUM(F7:XFD7))?
i mean why you don't present SUM(F7:XFD7) at first?

[Olly]

If there are no cell dependencies or constraints, then why would you need to find the last number in the row? Just sum the whole (remainder of the ) row, as in post #6.