Cactus1993
asked on
Excel CountIf Question 2
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!
Workbook11.xlsx
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!
Workbook11.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER