I'm looking for a formula that will sum the numeric values of three cells (K16, K17, K18). The tricky part is that each of those three cells is using a formula to populate its number. Simply adding them up or using the sum function doesn't work if any of those three cells are not calculated. I want to get the total sum (in cell K20) using whichever cells are populated with a number (even if it's only using 1 or two cells). K20 should also be blank or "N/A" by default (and not 0). I've uploaded a sample workbook. Thank you for the help!
Bookmarks