Sum non empty cells based on single value

[Marvinexcel]

Good day experts,

I am wondering if I can sum up non empty cells but it should add only single value for every group of inputs:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD="align: center"]Sum[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]

Appreciate your help on this query.
Thank you so much.

 

[Rick Rothstein]

I am wondering if I can sum up non empty cells but it should add only single value for every group of inputs:

Will the numbers in each cell of a group always all be equal to each other as your example shows?

What is the maximum value a number in a cell can be?

 

[Marvinexcel]

Will the numbers in each cell of a group always all be equal to each other as your example shows?

What is the maximum value a number in a cell can be?

Yes Sir. The numbers in each cell of a group will always be equal to each other and there will be no maximum value.

 

[Rick Rothstein]

Yes Sir. The numbers in each cell of a group will always be equal to each other and there will be no maximum value.

Give this array-entered** formula a try...

=A1+SUM(IF(A1:I1="",B1:J1))

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

Note that if your data range ends at a different column from your example's Column J, then change the "J" in "J1" to that column letter designation and the "I" in "I1" should change to the column letter designation for the preceding column.

 

[Marvinexcel]

Give this array-entered** formula a try...

=A1+SUM(IF(A1:I1="",B1:J1))

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

Note that if your data range ends at a different column from your example's Column J, then change the "J" in "J1" to that column letter designation and the "I" in "I1" should change to the column letter designation for the preceding column.

This solves it... thank you so much.