Sum a range of cells in a row based on values in another row

[Rosadocc]

Hi, Thanks in advance for any advice on this.

I am trying to get one cell to calculate a sum in a range of cells up to the cell/column that has a value on another row. Please see my example below:

A1 should sum values in B1:E1 based on the last column that has a value in row 2. In the example above, the sum should be B1:C1 since the last value in row 2 goes up to column C.

 

[DanteAmor]

Try this:

varios 01nov2022.xlsm
	A	B	C	D	E
1	48	14	34	33	63
2		12	16
Hoja4

Cell Formulas
Range	Formula
A1	A1	=SUMIF(B2:E2,"<>",B1:E1)

 

[Rosadocc]

Try this:

varios 01nov2022.xlsm
	A	B	C	D	E
1	48	14	34	33	63
2		12	16
Hoja4

Cell Formulas
Range	Formula
A1	A1	=SUMIF(B2:E2,"<>",B1:E1)

Awesome! Thanks that worked.