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.
Another approach would be to use a Pivot Table to get monthly totals.
When you suggested a pivot table I explored using one, but my sheet has many columns and it would make it more difficult to evaluate the data. I wanted to be able to review the data for the month with the total right there instead of having to check two tables. Thank you for the suggestion