sumproduct to sum total value not count occourances

[Peter1973]

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

 

[Akashwani]

Hi,

Does this work for you?...

=SUMPRODUCT(--(stores!$A$3:$A$4996='run times'!$A9)*(stores!$F$3:$F$4996="D")*(stores!$G$3:$G$4996<>""),(stores!$H$3:$H$4996))

I hope that helps.

Ak