Forum Discussion
Solved
Help with a formula
I'm using Excel to track hours, costs and payments. I'm not very knowledgeable in excel and I'm doing the best I can. In F2 to get the cost per day I've used =IF(ISBLANK(C2),"",(C2*E2)+D2) In...
Select File > Options > Formulas.
Scroll down to the section 'Error checking rules'.
Clear the check box 'Formulas which omit cells in a region'.
Click OK.
If you're OK with zeros on days/weeks without hours, you could use
=C2*E2+D2
in F2, and
=IF(WEEKDAY(A2)=7, SUMIFS(F$2:F2, A$2:A2, ">"&A2-7, A$2:A2, "<="&A2), "")
in G2.
In H2:
=IF(A2=EOMONTH(A2, 0), SUMIFS(F$2:F2, A$2:A2, ">"&EOMONTH(A2, -1), A$2:A2, "<="&A2), "")