SUMPRODUCT with month and criteria

[Kirbstomp1287]

I am trying to use a SUMPRODUCT function with the MONTH function to get a monthly count of specific data.

Essentially I need the function to look for the month (formatted: 1/25/19), then the initials from box AB4 in column D, then the text "Forecast" from column J to get a count of text "Met DLT" from column AP.

Here is the code I have so far that gives me a zero but should be 36.

=SUMPRODUCT(--(MONTH(F2:F9999)=6)*(J2:J9999="Forecast")*(AP2:AP9999="Met DLT")*(D2:D9999=AB4))

Any help would be much appreciated!

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.