Forum Discussion

hawkeye300's avatar
hawkeye300
Copper Contributor
Nov 11, 2022

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.

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

excel
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Nov 11, 2022

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

Resources