How to calculate total even if one of the cells is left blank

[Banana112233]

So title says it all, I want to calculate this field:

Even if I leave out some cells blank, it still calculates total:

 

[Peter_SSs]

If the cells are blank, your formula should give the sum. However, if any of the cells contain "" then it won't sum, but those cells aren't blank even though they may look blank.
In any case, try
=SUM(B3;E3;I3:K3;M3)

 

[Banana112233]

Yes, the cells weren't blank, they had formulas in them.
Thank you for the easy fix, I thought it was something more complex

 

[Peter_SSs]

Thank you for the easy fix,

No problem, glad to help.