Forum Discussion
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 c...
My sample range encompasses 10 rows, but you get the idea:
=SUMPRODUCT((G2:G10="Overhaul")*(LEN(F2:F10)>0)*(F2:F10-A2:A10<10))