Count Repairs Completed Within 10 Days in Excel Using SUMPRODUCT
Question details
Count parts with a specified repair type that were completed within 10 days of receipt.

- 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.
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.
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.
Click an empty cell where you want the count to appear.
Enter =SUMPRODUCT((G2:G100="OVERHAUL")*(A2:A100<>"")*(F2:F100<>"")*(F2:F100>=A2:A100)*(F2:F100-A2:A100<=10)) and press Enter.
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.

Count Repair Turnaround Times in WPS Spreadsheets
Use SUMPRODUCT in WPS Spreadsheets to count matching repair records by type and completion time.
- 1. Open the worksheet: Open WPS Spreadsheets and use Open to select your repair workbook.
- 2. Check the columns: Locate the received date, completion date, and repair type columns, and confirm that the dates are stored as dates.
- 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. Adapt the formula: Change the column ranges and OVERHAUL criterion to match your sheet, then press Enter to calculate the count.

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.




