formula
 

I need to add the number of times a number appears in a column. For example
if the number 1 appears three times I need a formula that would add the
number of times the number appears and put it on the bottom of the column

Thanks!
--
newteacher

formula
 

try

=countif(range,1)

hope this helps
regards from Brazil
Marcelo


"Newteacher" escreveu:

I need to add the number of times a number appears in a column. For example
if the number 1 appears three times I need a formula that would add the
number of times the number appears and put it on the bottom of the column

Thanks!
--
newteacher