Calculation Issues

Count Repairs Completed Within 10 Days in Excel Using SUMPRODUCT

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

Count parts with a specified repair type that were completed within 10 days of receipt.

Count Repairs Completed Within 10 Days Using Excel SUMPRODUCT
Product
Microsoft Excel and WPS Spreadsheets
Device & OS
not provided
Scenario
A worksheet contains repair types, received dates, and completion dates for parts.
Observed behavior
The desired result is a count of matching completed repairs whose completion dates fall within the chosen 10-day limit.
Before you start

Identify the columns containing received dates, completion dates, and repair types. Make sure date entries are stored as spreadsheet dates rather than text, and adjust the row ranges to match your data.

Solution 1Recommended

Use SUMPRODUCT to Count Completed Overhauls Within 10 Days

Use this formula when you need to count rows with a specific repair type and a completion date no more than 10 days after receipt.

The example assumes received dates are in column A, completion dates are in column F, and repair types are in column G. It includes completions exactly 10 days after receipt and excludes blank dates and completion dates before receipt.

1
Select a result cell

Click an empty cell where you want the count to appear.

2
Enter the formula

Enter =SUMPRODUCT((G2:G100="OVERHAUL")*(A2:A100<>"")*(F2:F100<>"")*(F2:F100>=A2:A100)*(F2:F100-A2:A100<=10)) and press Enter.

3
Adjust the criteria

Replace OVERHAUL with the repair type you want to count, and change A2:A100, F2:F100, and G2:G100 to matching ranges in your worksheet.

Use SUMPRODUCT to Count Completed Overhauls Within 10 Days
Choose the 10-day boundary: Use <10 instead of <=10 to exclude completions exactly 10 days after receipt. Avoid entire-column references in SUMPRODUCT when possible, as they can slow calculation.
Calculate repair turnaround times

Count Repair Turnaround Times in WPS Spreadsheets

Use SUMPRODUCT in WPS Spreadsheets to count matching repair records by type and completion time.

  1. 1. Open the worksheet: Open WPS Spreadsheets and use Open to select your repair workbook.
  2. 2. Check the columns: Locate the received date, completion date, and repair type columns, and confirm that the dates are stored as dates.
  3. 3. Enter SUMPRODUCT: Click an empty cell and enter =SUMPRODUCT((G2:G100="OVERHAUL")*(A2:A100<>"")*(F2:F100<>"")*(F2:F100>=A2:A100)*(F2:F100-A2:A100<=10)).
  4. 4. Adapt the formula: Change the column ranges and OVERHAUL criterion to match your sheet, then press Enter to calculate the count.
Count repairs using type and date conditions in one formulaOpen and edit Microsoft Excel XLSX and XLS filesUse bounded ranges to keep calculations manageable
QA img-9

Frequently Asked Questions

Does the formula include repairs completed exactly 10 days after receipt?

Yes. The <=10 condition includes exactly 10 days. Change it to <10 if the limit must be strictly less than 10 days.

How do I count a different repair type?

Replace "OVERHAUL" in the G2:G100 condition with the type used in your repair-type column, such as "REPAIR".

Why are blank completion dates excluded?

The F2:F100<>"" condition requires a completion date, so unfinished records are not included in the count.

What if a completion date is earlier than the received date?

The F2:F100>=A2:A100 condition excludes those rows. Check the source dates if you expect such a record to be counted.

Why does the formula return an error?

Check that all SUMPRODUCT ranges cover the same number of rows and that date cells contain valid spreadsheet dates rather than text or errors.