I know how to use countif in a range but what if I want to add text in a big
spreadsheet when the text is not in a range so I can total how many
supervisors are sched for pm's?
A B C
1 Shift Classification Supervisor
2 day orientee
3 pm orientee
4 pm S
4 day S
5 pm S