Forum Discussion
Formula Help
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? The...
Simply use
=SUM(J4:K4)
Then fill down.
The SUM function ignores blank cells, so if column J is blank, SUM will return the value from column K only.