Countif problems

terryc

Board Regular
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?

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

tony0682

Board Regular
Try this

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

MarkAndrews

Well-known Member
or where your results are - & hide the range (column A)
Book5
ABCD
118118
219119
320120
421121
5220
6230
7240
8250
9260
10270
11280
12290
13300
14310
15320
16330
17340
18350
19360
Sheet1

Replies
1
Views
51
Replies
2
Views
64
Replies
4
Views
133
Replies
9
Views
200
Replies
3
Views
151

1,136,595
Messages
5,676,707
Members
419,644
Latest member
KeelsM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back