Adding a row but if a cell is blank use an alternate cell

[Beh162]

I'm trying to add the value of cells, but if it's blank I want to use another cell.

105 (A1)	106(B1)	107	108
110(A2)	125

What I'm trying to do is add the bottom row (110+125...) but when the cell is blank I need to use the number above it. So in the example it would be 110+125+107+108. Is this possible?
Thanks!

 

[JoeMo]

If you are using MS 365:

Book1
	A	B	C	D
1	105	106	107	108
2	110	125
3
4	450
Sheet12

Cell Formulas
Range	Formula
A4	A4	=SUM(IF(A2:D2="",A1:D1,A2:D2))

Otherwise, confirm the formula in A4 using ctrl+shift+enter.

 

[Beh162]

Thank you that did work in my version

 

[JoeMo]

Thank you that did work in my version

You are welcome - thanks for the reply.