COUNTIF multiple criteria using dates?

[hissonrr]

Good day all,

In short I am trying to get a number using the COUNTIF function that has two criteria, the first being simple text in a column, but the second being that is is between two dates in another column and the same row.

To make it easier i will make a quick table...

So basically how would I write a formula that counts the number of rows where RH (in column D) is between 1/1/2018 and 1/1/2019 in column A?

In this example the formula would yield 2 because there are two rows where RH in column D falls between 1/1/2018 and 1/1/2019 in column A...


Any help would be appreciated as i am not very good with dates in formulas.

-R


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3/4/2018[/TD]
[TD]null[/TD]
[TD]1[/TD]
[TD]RH[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]5/2/2018[/TD]
[TD]null[/TD]
[TD]2[/TD]
[TD]RH[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]6/2/2017[/TD]
[TD]null[/TD]
[TD]3[/TD]
[TD]SM[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10/10/2018[/TD]
[TD]null[/TD]
[TD]4[/TD]
[TD]SM[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1/2/2017[/TD]
[TD]act[/TD]
[TD]5[/TD]
[TD]RH[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Try:

=COUNTIFS(D1:D5,"RH",A1:A5,">=1/1/2018",A1:A5,"<1/1/2019")

 

[hissonrr]

Thanks Joe,

You rock!

 

[Joe4]

You are welcome.