suppose your data is in A1:K1
![enter image description here](https://i.stack.imgur.com/KiT1J.png)
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
![enter image description here](https://i.stack.imgur.com/p3tjX.png)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…