I have a sheet with employee time logs, as follows:
Name Day1 Day2 Subtotal of 'OFF' days this period Jess PRESENT OFF 1 Bob PRESENT PRESENT 0 Name Day3 Day4 Subtotal of 'OFF' days this period Jess PRESENT PRESENT 0 Bob OFF OFF 2
I need to create an automatic total of the number of days off each employee has had. How could I do this?
=COUNTIF(1:100,"OFF") would return the total number of off days, but is there a way to get this total only rows where the first cell contains "Jess"?
(In this example, "OFF" is "STRING" in my question, while "Jess" is "IFTEXT")