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

	A	B	C	D
1	3/4/2018	null	1	RH
2	5/2/2018	null	2	RH
3	6/2/2017	null	3	SM
4	10/10/2018	null	4	SM
5	1/2/2017	act	5	RH

<tbody>
</tbody>

 

[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.