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

  Neil-321636 16:40 09 Feb 2004
Locked

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

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans ├ęchec ?