This is similar to a question I asked before, but I need an answer that takes into effect the blank-appearing cells actually have formulas in them, for which the previous answer provided to me does not work.
What formula (no array, please) can I enter in column S to simply count the number of shifts each employee (LL, ME, RC, etc.) have for the week in the attached spreadsheet? I'm having an issue with the text-style entry of the hours not computing in the formulas I've tried.
Thanks in advance!