HELP - Need formula

[Cathy]

Hello and thank you for helping me.

I have a column on numbers and at the end of the column I
need to find out how many times a certain number appears.

ex: 1
4
6
1
2
1

Total of 1 = 3

In the small example above the number 1 appears 3 times.
I cannot figure out the formula that looks only for a
certain number and the provides me with a total number of
times that number appears.

I would appreciate any help that you can provide.

Sincerely,
Cathy

 

[Peo Sjoblom]

=COUNTIF(A2:A200,1)

 

[Guest]

Thanks Peo, but it does not provide me with the total on
how many times 1 appears in the column. Any suggestions.

 

[Cathy]

Peo, ingore my last posting. It works great. Thank you
very much.
Cathy

 

[may]

Assuming B1 is where you are going to type the number you
want counted and Column A is your column you want the info
from:

=COUNTIF(A1:A6,B1)

 

[b.v.dam]

Hello Cathy,

This afternoon I sent about 10 answers to several
questions but I all got them back due to mail delivery
system error.

I can send you an example how to do it, it is not
difficult. Please inform me if your e-mailaddress:
(e-mail address removed) is correct then I will mail it.

Bye,

Bert