Count Question

[keyboard1960]

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

 

[Albert 1]

=COUNTIF(B2:B49,"=3")

 

[keyboard1960]

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

 

[plettieri]

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