Combining 2 formulas - having trouble - please assist!

[kirrash]

Two columns of data - first formula looks for target month...which is in this case is July:
=SUMPRODUCT(--(D2:D10<>""),--(MONTH(D2:D10)=7))

Second formula looks for a keyword. I have to report when I post clients to new adult family homes to my supervisor. Second formula:

=COUNTIF(G2:G5,"for*")

the "for" would be like "kitsap family home" etc. I used "for" to simplify.

If I had 20 dates in July, but only 5 "for" during the month, that is what I would like. I'm feeling like this might be a nested formula answer?
Thank you!

[LearningByError]

I think I know what you are getting at and if you can post an example I'll be glad to try and help.

~LearningByError

[63falcondude]

Hello and welcome to the forum.

Maybe something like this:

=COUNTIFS(D:D,">="&DATE(2018,7,1),D:D,"<"&DATE(2018,8,1),G:G,"for*")

[kirrash]

LearningByError - sorry I didn't get back to you sooner - had to work outa town!

63falcondude - thank you, EXACTLY what I needed!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[kirrash]

Thank you, was perfect!