+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    08-12-2014
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    7

    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+



    Can some one please help?





    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    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)
    Click just below left if it helps, Booşathì

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    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.
    Attached Files Attached Files
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match Formula, or VLookup not helping with this problem
    By WimpieOosthuizen in forum Excel General
    Replies: 1
    Last Post: 07-24-2014, 03:56 PM
  2. Helping with formula which calculate payment term
    By jowii307 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2014, 09:10 AM
  3. [SOLVED] Formula to tag list of Items with Grouping Number
    By superxl in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-04-2013, 11:00 AM
  4. Request for helping the right formula creation
    By PRADEEPB270 in forum Excel General
    Replies: 1
    Last Post: 05-06-2010, 06:45 AM
  5. [SOLVED] Need helping with my formula please...
    By Altstatten in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2006, 04:50 PM

Tags for this Thread

Bookmarks

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