HELP - Need formula

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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
 
Thanks Peo, but it does not provide me with the total on
how many times 1 appears in the column. Any suggestions.
 
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)
 
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
 
Back
Top