Try initiating the formula with a check to see if entries are made for the day:
so if C20:F20 are blank, then return a blank, otherwise proceed with the calculations.
You can substitute a 0 for the "" to return 0 instead, if preferred.
Do similar for other columns (or you can point to the previous result and indicate if that result is blank, then blank, else continue).
Note: If you are leaving Saturday/Sunday fields blank or entering 0's, then you can use SUM() formulas at the bottom to avoid the #VALUE errors...
Bookmarks