How to count the number of occurrences in a range [Closed]

Report
Posts
2
Registration date
Monday October 16, 2017
Status
Member
Last seen
October 17, 2017
-
Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
-
I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occur in a column. Is there a way to do a range of numbers in the same column and get each numbers occurrence count?

2 replies

Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
142
STUDENTFJR, Good afternoon.

Suppose:
A1:A1000 --> Your column of data.

If you want to count numbers in a range from 1 to 20, try to do:
C1 --> =COUNTIFS(A1:A1000, ">=1", A1:A1000,"<=20")

If you want to count a specific number, try to do:
D1 --> =COUNTIF(A1:A1000, 32)
To count how many times 32 appears in a range of A1:A1000

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
2
Registration date
Monday October 16, 2017
Status
Member
Last seen
October 17, 2017

The last suggestion is close but what I need is to count every number that that appears in that group of numbers, 1 - 70 say. How many times each number in that range appear in a column in excel. How many times 32 is in the column, how many times 2 appears in the column. and so on. 2 = 14 occurrences, 4=5 occurrences, 20= 5 occurrences........... Thank you for your assistance this is a project I am working on to resolve how many particular part options occur and 6 numbers can be any combination of numbers 1 - 70 for part identification and option for that part. Each number can appear only once in the 6 number combination. Again thank you for your time and quick assistance on this challenge in excel.
Posts
1915
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 13, 2021
142
STUDENTFJR, Good afternoon.

Could you please save a small example of your spreadsheet, showing what the results would be?

Save the worksheet to a free website, www.sendspace.com and put the download link here.

So our help should be faster and really help you in a conclusive way.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!