+ Reply to Thread
Results 1 to 2 of 2

COUNTIF Problems!!

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    Northampton
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy COUNTIF Problems!!

    Hi,

    Please can someone tell me if the following is at all possible as I cannot seem to get any formulas right!

    I have the following data (shortened version!)

    Column A Column B
    Years Experience Years experience in specialism
    3.0 3
    4.0 0.16666
    3.0 0.16666
    5.0 5
    12.0 3
    4.0 4
    15.0 0.75
    2.5 2.5
    5.0 3
    4.0 1.6666
    13.0 13


    I am trying to fit this information into ranges of less than 1 year, 1-2 years, 2-5 years, 5-10 years and 10 years plus in orger to create a graph. But I have a lot of data which would take a long time to tally manually into these ranges.
    These variables are dependent on one another and therefore 1 row expresses 1 participant.

    I understand that if I use the formula below, that I can calculate how many there are of those who have less than 1 yrs exprience and less than 1 years experience in the specialism.
    =COUNTIFS(A:A,"<1",B:B,"<1")

    I don't understand whether it is possible to create number ranges in the formula. so for example where someone has 4 years overal experience but only 1.6666 years in their specialism they fall into the category 2-5 years in overall experience but 1-2 years in their specialist experience. but creating a formula for this ranges includes everybody with more than 5 years and less than 1.

    Can anyone help at all???

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: COUNTIF Problems!!

    Hi,

    perhaps have a look at the FREQUENCY function. Be aware that this is an arry function and should be committed with Ctrl+Shift+Enter

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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