L
Legacy 469449
Guest
Hi,
I'm trying to create a new rota for my workplace [Google Sheets – image below-
Column D needs to be a total number of nonblank cells, but only if they're not any of SICK, HOL, SAB, OFF, MAT, PAT, R/O. (So in that image, it would just be 4).
I'm currently using
, which is working in not counting the SICK, but not anything else.
(I can't just ask it to count 12; 12.30; 1.30, as there will be far more criteria that could be added).
Thank you so much for any help you can give here
I'm trying to create a new rota for my workplace [Google Sheets – image below-
Column D needs to be a total number of nonblank cells, but only if they're not any of SICK, HOL, SAB, OFF, MAT, PAT, R/O. (So in that image, it would just be 4).
I'm currently using
Excel Formula:
=COUNTA(G16:AO16)-SUM(COUNTIFS(G16:AO16,{"SICK","HOL","SAB","OFF","MAT","PAT","R/O"}))
(I can't just ask it to count 12; 12.30; 1.30, as there will be far more criteria that could be added).
Thank you so much for any help you can give here