Counting # of times a word appears when associated with name and date range

[operationsboy1990]

Hello

I'm looking to count how many times the word "forced release" appears when associated with a certain name within a date range.

Name range is in column "A"
Date range is in column "B"
The Status name is in column "D"

The date range i want to set is in column M1 and N1


please help thank you in advance

 

[Marcílio_Lobão]

operationsboy1990, Good morning.

Try to use:

=COUNTIFS(A1:A100,NAME RANGE,B1:B100,">="&M1,B1:B100,"<="&N1,C1:C100,"forced release")

Is that what you want?
I hope it helps.

 

[operationsboy1990]

THANK YOU SOOOO MUCH. This worked to perfection

operationsboy1990, Good morning.

Try to use:

=COUNTIFS(A1:A100,NAME RANGE,B1:B100,">="&M1,B1:B100,"<="&N1,C1:C100,"forced release")

Is that what you want?
I hope it helps.

 

[Marcílio_Lobão]

Thanks for the feedback.

Glad to have helped you.

Have a nice day!