]SK[ Posted November 29, 2011 Share Posted November 29, 2011 I'm creating a spread sheet that will have a column with entries added to it ranging from 1 to 5. What I want to do is read the whole column and count how many occurrences of each of the 5 numbers. There will be a seperate cell for each count. For example... 1 2 1 2 3 5 3 4 1 1 1 The total occurrences of 1 is 5. The total occurrences of 2 is 2. The total occurrences of 3 is 2. etc. Thanks beforehand. Link to comment Share on other sites More sharing options...
0 Haggis Veteran Posted November 29, 2011 Veteran Share Posted November 29, 2011 ok lets say its in the range A1:A100 you can use this =COUNTIF(A1:A100,5) This would count the amount of times 5 appears in that range Link to comment Share on other sites More sharing options...
0 kinetix63 Veteran Posted November 29, 2011 Veteran Share Posted November 29, 2011 =COUNTIF(A1:A10,x) Replace A1 and A10 with the appropriate range, and x with the number you're looking for. You might need to put the number in quotes if the values are stored as text. Link to comment Share on other sites More sharing options...
0 ]SK[ Posted November 29, 2011 Author Share Posted November 29, 2011 Cheers guys. As easy as that. Link to comment Share on other sites More sharing options...
Question
]SK[
I'm creating a spread sheet that will have a column with entries added to it ranging from 1 to 5.
What I want to do is read the whole column and count how many occurrences of each of the 5 numbers. There will be a seperate cell for each count.
For example...
1
2
1
2
3
5
3
4
1
1
1
The total occurrences of 1 is 5.
The total occurrences of 2 is 2.
The total occurrences of 3 is 2.
etc.
Thanks beforehand.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts