Is there a code or a way to do the following:
=COUNTIF(MGR!I2,"*X*")+ COUNTIF(TL!I2:I5,"*X*") +
COUNTIF(EMP!I2:I5,"*X*")
"X" symbolizes a "day off" so if it finds an X then I want it to mark as one. This code is working for me, but I'm trying to make it better. Instead of having to divide a schedule between all different titles, I'm trying to input it once and have it automatically search or exclude keywords...
Example would be: If it shows "manager" in A1:A40 then do not COUNTIF(MGR!I2,"*X*") or if it shows "manager" in A1:A40 then COUNTIF(MGR!I2,"*X*")
I hope this makes sense.
Thanks in advance
Bookmarks