Category the list of tenure employees

[Heera]

Hi,

I have list of employees with their tenuity in number of days in column A and I need in small table that how many employees are in 00-30 days , 31-60 days , 61-90 days and above +91 days. Below the data required in table.

Please provide me the formula for each tenuity.

Tenuity	Total employee count
00 - 30 <tbody> </tbody>
31 - 60 <tbody> </tbody>
61 - 90 <tbody> </tbody>
90 above <tbody> </tbody>

<tbody>
</tbody>

<tbody>
</tbody>

thanks in advance.

 

[Christiaan]

Assuming agents are in column A and they tenuity in colum B I would use something like this:

=COUNTIF(B1:B10,"<"&30)
=COUNTIFS(B1:B10,">"&30,B1:B10,"<"&61)
=COUNTIFS(B1:B10,">"&60,B1:B10,"<"&91)
=COUNTIF(B1:B19,">"&90)

Hope this helps,
Christiaan