Excel blank cell reference to add cell next to it twice

Question

Is there a way to sum a row of cells up, but if a cell in the row is blank then add the cell on the left side of the blank cell two times?

Answer 1

suppose your data is in A1:K1

Add any dummy text in cell next to it L1 (which can be a hidden column), thereafter add this formula in the cell next to it M1

=SUM(A1:K1, SUMPRODUCT((A1:K1)*ISBLANK(B1:L1)))

You'll get your results