Formula help using SUMPRODUCT


Good Morning All, 

Hello, I need a formula that can calculate how many parts have been overhauled/repaired within 10 days, We have a column for overhaul or repair, a column for date received and a column for date completed.

I've tried the formula below, but it is returning- 0. So I am hoping someone can assist me with getting the correct formula.


1 Reply


My sample range encompasses 10 rows, but you get the idea: