Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
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
<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
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