用Excel 做統計的問題？ 請各位幫幫手Thx!

Method (1) you can use countif as suggested:

Assume all your data in column A, then column B will have data like :

Cell B1 = 2
Cell B2 = 3
Cell B3 = 4
...
..
so in cell C1 you can type in this formula:

=countif(A:A, B1)

then it will show that how many times do that [2] appear in column A. You can copy that formula and copy to other cells in column B.

Method (2) Pivot Table.

Pivot table is a pretty convenient tool for you to handle the data.

First highlight the range of the data, in this case is column A.

Then type:
ALT + D +P

and you can see a wizard to setup a pivot table.

Click Next to select range (which is column A)
Click Next to select where you want to output the report, or you could choose to output to a new worksheet.
Click FINISH.

You should see 4 square box on the new worksheet and a Pivot Table field list on the right.

You can then drag that data in the Pivot Table field to the left which says [DROP ROW FIELDS HERE]. After that, drag the same data in the pivot table field to [DROP DATA ITEMS HERE] . Pivot table will show you how many [2] ,[3] are tehre in the data.

There are lot more functions you can use in Pivot table.

I hope that helps.

See if this works:

to count the number of 2s, you may use =countif(range of cells,2)
to count the number of 3s, you may use =countif(range of cells,3)

follow this and you can count others as well.