Forum Discussion
calculate over certain value
Are you able to post a copy of the spreadsheet then, either to OneDrive or GoogleDrive, pasting a link here that grants edit access to anybody using it?
And if you could explain just a bit more clearly this statement:
the top right corner is where i am attempting the get the information i want every blank white cell to calculate to preferrebly one cell in the overtime column.
The direction from "every blank white cell" to "preferably one cell in the overtime column" is a bit ambiguous, and ambiguity doesn't serve us well when we're writing Excel formulas.
The easiest solution (and therefore clearest) might be to have one OT cell per day and then run totals for each month. In fact, one could just add a column to the main spreadsheet to contain that daily OT figure, rather than having it off to the side.
Thank you mathetes with your formula i came up to a round-about way to get to what a i needed.
Thank you again