# Need helping using a formula that will count the number of ppl in each grouping

1. ## Need helping using a formula that will count the number of ppl in each grouping

Hey,

i am trying to make a countsif formula that counts the tenure of the ppl (years and months column) , and groups them accordingly.

0-1year, 0months

1-2year, 0months

2-3years, 0months

3+

Thank you

2. ## Re: Need helping using a formula that will count the number of ppl in each grouping

tRY

=COUNTIFS(B:B,">="&0,B:B,"<"&1)

=COUNTIFS(B:B,">="&1,B:B,"<="&2)

=COUNTIFS(B:B,">"&2,B:B,"<="&3)

=COUNTIFS(B:B,">"&3)

3. ## Re: Need helping using a formula that will count the number of ppl in each grouping

Try this...
``Please Login or Register  to view this content.``
I think you have input the wrong desired output. Check it manually.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1