Excel-how many times a number appears in a list?

  Neil-321636 16:40 09 Feb 2004

Please could someone tell me the easiest way to count the number of times numbers appear in a list. For example, in a list of test scores I want to find how many people scored 6 marks, how many got 7,8 etc. I've looked at the FREQUENCY function but don't understand the help in Excel.

Thank you

  Sheila-214876 17:12 09 Feb 2004

Try the Function "Countif"

  Pete1 17:13 09 Feb 2004

Hi, I would personally use the COUNTIF function. When selecting range highlight your list, and the criteria would be the mark ie 6
Hope this helps

  pc moron 18:21 09 Feb 2004

Depending on the number of scores you wish to count, a quick way is to use a Pivot Table- there are no formulas to type/setup.

I'm assuming Excel XP but it should work in other versions.

Your data is in two columns called Name and Score for example.

Select your entire list (including the column headers).

From the menu bar select Data> Pivot Table and Pivot Chart Report.

Click Next, then Next again, then Finish.

Drag the Score to Drop Row Fields Here and drag Name to Drop Data Items Here.

Job Done!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy A8 review: Hands-on

Illustrator Juan Esteban Rodriguez on creating highly detailed official film posters for Star Wars…

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?