excel count dates

[rjgtavares]

Good morning, I'm using the following formula:
= DATA! $ BL $ 2: $ BL $ 995, "Alex", DATA! $ E $ 2: $ E $ 995, "MTM50)
which is working perfectly, but I need to add a date criterion, which only counts the cells that are common to: "JULY", "ALEX" and MTM50 (machine).

in other words, I want excel to count the cells that exist with the "July" date and with the name "Alex" and the machine MTM50. You must understand the 3 requirements.

If you can help me i would apreciate.

 

[jorismoerings]

Hi,

assuming you're having a date column on sheet DATA in column A!

Thry this:

=SUMPRODUCT((DATA! $ BL $ 2: $ BL $ 995="Alex")*(DATA! $ E $ 2: $ E $ 995="MTM50")*(MONTH(DATA! $ A $ 2: $ A $ 995=7))

 

[TopUser]

Hello!

Did you try CountIfs Formula?, you can use text function to extract the month of the date if needed.

 

[rjgtavares]

Hi,

assuming you're having a date column on sheet DATA in column A!

Thry this:

=SUMPRODUCT((DATA! $ BL $ 2: $ BL $ 995="Alex")*(DATA! $ E $ 2: $ E $ 995="MTM50")*(MONTH(DATA! $ A $ 2: $ A $ 995=7))

the date has this format: "16-07-2019 15:41:23"

I did thatbut it still appliesto every months and doesn’t specify to July, can it be the Date configurations?The date is being imported from VBA, and is with the NOW formula.

 

[rjgtavares]

yes actualy thats the formula i were using but it didnt copied sorry.