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

[TABLE="width: 290"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]State[/TD]
[TD][/TD]
[TD]Created On[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD]Qualified[/TD]
[TD][/TD]
[TD="align: right"]30/04/2019[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD]Qualified[/TD]
[TD][/TD]
[TD="align: right"]01/05/2019[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD]Qualified[/TD]
[TD][/TD]
[TD="align: right"]28/05/2019[/TD]
[/TR]
[TR]
[TD]Alex[/TD]
[TD]Qualified[/TD]
[TD][/TD]
[TD="align: right"]03/03/2019[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD="colspan: 2"]Not Qualified[/TD]
[TD="align: right"]04/05/2019[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Qualified[/TD]
[TD][/TD]
[TD="align: right"]05/05/2019[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Qualified[/TD]
[TD][/TD]
[TD="align: right"]06/05/2019[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD="colspan: 2"]Not Qualified[/TD]
[TD="align: right"]07/05/2019[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD="colspan: 2"]Not Qualified[/TD]
[TD="align: right"]08/05/2019
[/TD]
[/TR]
</tbody>[/TABLE]


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