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???
Bookmarks