See two methods to Count Entered Results For Shift & Date Range using COUNTIFS function:
1. Introduction to a well asked question
2. Create Defined Names
3. Create COUNTIF Formula #1, where we have 4th criteria as “Greater Than or Equal to Zero”.
4. Create COUNTIF Formula #2, where we have 4th criteria as “Not Empty Cells”.