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

  Neil-321636 16:40 09 Feb 04

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 04

Try the Function "Countif"

  Pete1 17:13 09 Feb 04

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 04

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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5