• 0

Excel - formula needed


Question

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

  • 0

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

  • 0

=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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.