how to get a count of attrition when employee was less than 15 days in the system

[zorg2780]

Hi team

looking at getting the count of employees that have attrited, e.g. in cell A1...

this can only be done if the agent (found in range C1:C42) were present for less than 15 days but more than 0 days..

i have used this formula but all i get is a value error. please help

=IF(E21:E62="Resigned",IF(E21:E62="NCNS",COUNTIFS(C21:C62,">0",C21:C62,"<15"),""))

 

[Aladin Akyurek]

Hi team

looking at getting the count of employees that have attrited, e.g. in cell A1...

this can only be done if the agent (found in range C1:C42) were present for less than 15 days but more than 0 days..

i have used this formula but all i get is a value error. please help

=IF(E21:E62="Resigned",IF(E21:E62="NCNS",COUNTIFS(C21:C62,">0",C21:C62,"<15"),""))

Perhaps...

=SUM(COUNTIFS(E21:E62,{"Resigned","NCNS"},C21:C62,">0",C21:C62,"<15"))

 

[zorg2780]

Thank you sir it did work...

cheers n merry christmas

 

[Aladin Akyurek]

Thank you sir it did work...

cheers n merry christmas

You are welcome.