Counting how many times a certain number appears in a column of ce

M

Melinda

(I am not sure if this is possible) I am trying to configure a formula to tell me how many times certain number appears in a column of numbers. Is this possible? If so how do create the formula? Thanks in advance for your help.
 
J

JE McGimpsey

One way:

If your "certain number" is in B1, count the number of times the number
appears in column A with

=COUNTIF(A:A,B1)
 
M

Melinda

Okay lets see if I have it. If I want to see how many times the number 26 appears in cells in E1-E61 the formula should read:

=countif(26:26,e1:e61)
 
Top