Formula Help

Copper Contributor

I need help writing a formula in column L.  The calculation for L4 is simply the sum of J4=K4.  My question is what formula can I use in L column that will only use the K4 result if J4 is blank?  Then if J4 has a value, the L column would go back to the sum of J4 and K4.  You can see that I couldn't figure out how to sum the values in L5 and the result shows up as FALSE.

Excel Help.PNG


1 Reply


Simply use


Then fill down.

The SUM function ignores blank cells, so if column J is blank, SUM will return the value from column K only.