I have this formula and I cannot get it to work for me
=IF(E11="",0,SUM(F6:M6,B11:E11)) the cell which the formula is in is E15, so if E11 has no value then I want E15 to be "0",,
If E11 has a value then the formual SUM(F6:M6,B11:E11) needs to apply. Thank you.
E6 5,000
E11 0
E15 0
E6...