Apr 14 2021 02:30 PM
Hello,
I am developing a schedule for staff at work. In the template (found here: https://templates.office.com/en-us/employee-absence-schedule-tm03987167) I want to document days that our staff reports to the office, but I don't want those days counted in the total column. What do I do?
Apr 14 2021 02:43 PM
@Damien1020 The easiest way is to subtract the that number using -COUNTIF(range, "in office code") so in the attached example I added "O" as the key for in office and changed the total count formula to be:
=COUNTA(January!$C7:$AG7)-COUNTIF(January[@[1]:[31]],"O")
Apr 14 2021 03:07 PM
Apr 14 2021 03:38 PM
Apr 14 2021 05:29 PM
@Damien1020 you can do the same thing:
=SUBTOTAL(103,E$7:E$11)-COUNTIF(E$7:E$11,"O")
I updated Jan tab in the attached.