I am creating a sick log. The formula I am using to tally hours of sick time is very simple located in cell E100:
=SUM(E3:E99)
However, I also have check boxes to the right of column E (F3:F99). When a box is checked, I want for the hours in the corresponding E column to NOT be added into the sum.
For instance, if the box in F5 is checked, I do not want the hours located in E5 to be counted in the total located in E100.
Thoughts?
Bookmarks