Formula help using SUMPRODUCT

Visitor

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.

=SUMPRODUCT((G:G="OVERHAUL"),NOT(ISBLANK(F:F)),F:F-A:A<10)

1 Reply

@hawkeye300 

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

 

=SUMPRODUCT((G2:G10="Overhaul")*(LEN(F2:F10)>0)*(F2:F10-A2:A10<10))