I am using :
=SUMPRODUCT(--(stores!$A$3:$A$4996='run times'!$A9),--(stores!$F$3:$F$4996="D"),--(stores!$G$3:$G$4996<>""))
Kindly assisited with on here.
I now need this to be altered so it looks in A3:A4996 for cells that = Run times A9, then in those cells look in F3:F4996 for cells that ="D", then in those cells look in G3:G4996 for cells that are not blank then in the cells that meet all the criteria return the total of all cells in H3:H4996
Any help appreicated
=SUMPRODUCT(--(stores!$A$3:$A$4996='run times'!$A9),--(stores!$F$3:$F$4996="D"),--(stores!$G$3:$G$4996<>""))
Kindly assisited with on here.
I now need this to be altered so it looks in A3:A4996 for cells that = Run times A9, then in those cells look in F3:F4996 for cells that ="D", then in those cells look in G3:G4996 for cells that are not blank then in the cells that meet all the criteria return the total of all cells in H3:H4996
Any help appreicated