Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
HI Guys
i am doing a count ifs statement on the example data below
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The logic i am using is count Name if name equals Alex and stats Qualified and date range is between 01/04/2019 and 30/04/2019 then count name and divide this by the count of name where name is alex and date range is between 01/04/2019 and 30/04/2019. the answer should be 2/3
from previous post io did i used the following formula but now the date field has date and time this doesnt work
=COUNTIFS(A2:A10,"Alex",B2:B10,"Qualified",C2:C10,">="&DATEVALUE("4/1/19"),C2:C10,"<="&DATEVALUE("4/30/19"))
can any one help me correct this formula?
thanks guys
i am doing a count ifs statement on the example data below
<tbody> </tbody> |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The logic i am using is count Name if name equals Alex and stats Qualified and date range is between 01/04/2019 and 30/04/2019 then count name and divide this by the count of name where name is alex and date range is between 01/04/2019 and 30/04/2019. the answer should be 2/3
from previous post io did i used the following formula but now the date field has date and time this doesnt work
=COUNTIFS(A2:A10,"Alex",B2:B10,"Qualified",C2:C10,">="&DATEVALUE("4/1/19"),C2:C10,"<="&DATEVALUE("4/30/19"))
can any one help me correct this formula?
thanks guys