Use Excel COUNTIFS to Track Daily Job Progress by Manager
Question details
Create formulas that report daily job totals for each responsible manager without double-counting jobs that remain in the same status on later reports.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs to summarize jobs by manager, status, and reporting day or date range.
- Observed behavior
- Jobs can appear in the same status across multiple daily reports, so counting report rows alone may inflate the daily total.
Make sure the source data has separate columns for Manager, Status, and the actual completion or transaction date. Use real Excel date values rather than date text so date-based criteria return accurate results.
Count completed jobs by manager for one reporting day with COUNTIFS
Use this method when each job should be counted once based on its completion or transaction date.
COUNTIFS applies multiple conditions at once. Adding a start-of-day criterion and a next-day criterion includes all times recorded on the selected day while preventing jobs from being counted again solely because they remain visible in later status reports.
In your summary area, enter the manager name in H2 and the reporting date in I1. For example, use H2 for a manager such as Alex and I1 for the date to evaluate.
Confirm that column A contains Manager, column B contains Status, and column C contains the completion or transaction date. Adjust the column references in the formula if your layout is different.
Select the result cell and enter: =COUNTIFS($A:$A,$H2,$B:$B,"Completed",$C:$C,">="&$I$1,$C:$C,"<"&$I$1+1). Press Enter, then fill the formula down for other managers.
Count against the source system’s completion or transaction date column, not the date when a status was copied into a later report. This ensures one completed job contributes to only one day’s total.

Sum job values by manager and date with SUMIFS
Use this method when each job has a numeric value, such as hours, revenue, quantity, or points, that must be totaled instead of simply counted.
Track Manager Job Progress with COUNTIFS in WPS Spreadsheet
WPS Spreadsheet lets you build manager-by-day job reports with COUNTIFS and SUMIFS using the same familiar formula structure. Create a date-driven summary that counts completed jobs once according to their completion date and manager.
- 1. Open the job data in WPS Spreadsheet: Open the .xlsx or .xls workbook in WPS Office and verify the Manager, Status, Date, and optional Value columns.
- 2. Create report input cells: In an empty summary area, enter a reporting date and list the manager names you want to evaluate.
- 3. Add a COUNTIFS daily total: Select the result cell, type the COUNTIFS formula with manager, status, and date-range criteria, and press Enter.
- 4. Fill the formula for each manager: Drag the fill handle down to copy the formula beside additional manager names, then change the selected date to refresh the report.

Frequently Asked Questions
Why does COUNTIFS use both a greater-than-or-equal-to date and a less-than date?
Using >=SelectedDate and <SelectedDate+1 captures every date and time on one calendar day. It is more reliable than matching an exact date when the source date column may include times.
How can I avoid counting a job again when it appears in the next day’s status report?
Use the job’s completion or transaction date as a criterion in COUNTIFS or SUMIFS. Do not count based only on the date that a status snapshot or report row was created.
Can I count jobs for a date range instead of a single day?
Yes. Replace the daily end criterion with an end-date cell, such as =COUNTIFS(A:A,H2,C:C,">="&I1,C:C,"<"&J1+1), where I1 is the start date and J1 is the end date.
When should I use COUNTIF instead of COUNTIFS?
Use COUNTIF only when one condition is needed, such as counting all jobs assigned to one manager. Use COUNTIFS when you need manager, status, date, or other criteria together.
Can I calculate an average job value for each manager?
Yes. Divide a SUMIFS result by the matching COUNTIFS result. Wrap the calculation with IFERROR if a manager may have no matching jobs, for example: =IFERROR(SUMIFS(...)/COUNTIFS(...),0).




