SUMPRODUCT with month and other 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.

Please Login or Register  to view this content.

Any help would be much appreciated!

[joeu2004]

See my responses in the similar discussion the mrexcel.com Excel forum.

[CARACALLA]

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do not try to use the Paperclip icon, as this does not work on this forum.

[AliGW]

See the similar discussion the mrexcel.com Excel forum.

Are you suggesting that this has been cross-posted?

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

As you are new I will add it for you
This is the second time we have to remind you of this rule after only two threads

https://www.mrexcel.com/board/thread.../#post-5376531