Count ifs with date range

[Imran Azam]

HI Guys

i am trying to create a formula where it does a count if the date range condition is matched else bring back blank, below is the data

Name	State		Created On
Alex	Qualified		30/04/2019
Alex	Qualified		01/05/2019
Alex	Qualified		28/05/2019
Alex	Qualified		03/03/2019
James	Not Qualified	04/05/2019
James	Qualified		05/05/2019
James	Qualified		06/05/2019
James	Not Qualified	07/05/2019
James	Not Qualified	08/05/2019

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

the logic i am trying to use is if Name is Alex and State = Qualified and created on is between 01/05/2019 and 30/05/2019( i just want may data) then return the count of the name, the formula i have done is below but it isn't working

=COUNTIFS(Name,"Alex",state,"Qualified",Created on,">=01/05/2019",D:D,Created on,"<=30/5/2019)/COUNTIF(Name,"Alex")

can anyone help with this?

thanks

 

[Joe4]

thanks what if i want the date range from 01/01.2019 to 01/05/2018, can this be done using same formula?

It depends on whether or not you want to include the May 1 date in your count. If so, then you will need to do something like Marcelo should to include that date.
If not, you can use the formula that Repush just posted (which will NOT include the May 1 dates).