Please can someone tell me how to do a cell count in Excel 2003, which counts a certain amount of numbers.?

Question

For an example if I had the values:
1
3
4
5
6
7
10
7
3
4
5
1
4

And I want it to count the amount of 3's there is, and return the amount (2 in this example).

Thanks!

Answer 1

If the cells to be evaluated are A2:A14, then:
=COUNTIF(A2:A14,"=3")

Answer 2

If you have your numbers in cells A1:A13 I would use the following formula in cell A15 and enter the number I want to count in cell B15, in your example, 3. When you want to see how many times a number is repeated, it is easier to edit a cell than the formula.

=COUNTIF(A1:A13,B15)

Answer 3

In the example given in the other solution
=COUNTIF(A2:A14,"=3")

the last part with quotes is not needed (it still works), just put a 3 in.

=COUNTIF(A2:A14,3)