Countif problems

[terryc]

Hi

I have a long list of data - about 3000 values, all integers between 18 and 30.

I want to count the number of times certain integers appear.

In the worksheet, I've set up a column with the following in:

=COUNTIF($B$2:$B$2977,18)
=COUNTIF($B$2:$B$2977,19)
=COUNTIF($B$2:$B$2977,20)
and so on to 30.

However, it is giving me some very strange answers. Basically, each of these numbers appears several hundred times in the list, but it's only giving me values like 2 or 4.

What am I doing wrong?

 

[tony0682]

Try this

=COUNTIF($B$2:$B$2977,"=18")
=COUNTIF($B$2:$B$2977,"=19")
=COUNTIF($B$2:$B$2977,"=20")

 

[MarkAndrews]

or where your results are - & hide the range (column A)

Book5
	A	B	C	D
1	18	1		18
2	19	1		19
3	20	1		20
4	21	1		21
5	22	0
6	23	0
7	24	0
8	25	0
9	26	0
10	27	0
11	28	0
12	29	0
13	30	0
14	31	0
15	32	0
16	33	0
17	34	0
18	35	0
19	36	0
Sheet1