# Count Question

#### keyboard1960

##### New Member
I realize this is probably very simple to do but I can't seem to figure it out. I have one column of information which contains numbers from 1 to 19. I just want to write a formula that counts how many times the number 1 or 2 or 3 is listed in this column. Example Column B2:B49 how many times is the number 3 listed. I've tried to use the count feature and it is not returning the right info. Help! Thanks

### Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
=COUNTIF(B2:B49,"=3")

Thank you very much Albert. I was leaving off the quotation marks in my formula. Thanks again for the fast reply. Byron

You might also try this to substitute the end of the formular toilook at spectic cell that you might find easier to change if you had a series of items to look up...(F1 being the cell to modify)

=COUNTIF(B2:B49,F1)

pll

Replies
17
Views
287
Replies
2
Views
168
Replies
8
Views
195
Replies
4
Views
120
Replies
3
Views
145

1,221,383
Messages
6,159,540
Members
451,571
Latest member
Qwissy

### 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.

### Which adblocker are you using?

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