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.

​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.   Read More

​