Forum Discussion
Damien1020
Apr 14, 2021Copper Contributor
Excel's absence schedule template: how do I omit a "key" from being counted in the table?
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 rep...
Damien1020
Apr 14, 2021Copper Contributor
Do you have a formula for the subtotal? I would like a formula that excludes "O." Much appreciated!
mtarler
Apr 15, 2021Silver Contributor
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.