LinkBack URL
About LinkBacks
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+
Can some one please help?
Thank you
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+
Can some one please help?
Thank you
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)
☚ Click ★ just below left if it helps, Boo?ath?
Try this...
I think you have input the wrong desired output. Check it manually.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks