Function Problems

Use Excel COUNTIFS to Track Daily Job Progress by Manager

Muhammad TalhaMuhammad Talha Nov 12, 2026 868 views

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.

Track Daily Job Progress by Manager with Excel Formulas
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.
Before you start

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.

Solution 1Recommended

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.

1
Set up the summary criteria

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.

2
Identify the source columns

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.

3
Enter the daily COUNTIFS formula

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.

4
Use the completion date as the counting date

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.

Count completed jobs by manager for one reporting day with COUNTIFS
Daily totals exclude repeat status records: The formula counts only rows that match the selected manager, Completed status, and the date interval from the chosen day up to—but not including—the next day.
WPS Spreadsheet formulas

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. 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. 2. Create report input cells: In an empty summary area, enter a reporting date and list the manager names you want to evaluate.
  3. 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. 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.
Use COUNTIFS to count each manager’s completed jobs for a selected reporting day.Use SUMIFS to total job hours, quantities, or values with the same criteria.Open and edit Microsoft Excel .xlsx and .xls workbooks with formula compatibility.Work in a lightweight spreadsheet interface with familiar rows, columns, and formula entry.
microsoft office alternative - wps office

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).