How do I count in Excel?

S

Steven

If I have a series of numbers, and I want to count the
amount of time the numer 3.7 appears, what would the
equation be??

Thanks for the help.
 
J

Jon

Steven said:
If I have a series of numbers, and I want to count the
amount of time the numer 3.7 appears, what would the
equation be??

Thanks for the help.
Click to expand...

Steven,

Try the "countif" function. Give it the range containing the series of
numbers, and the number you want to count, and it will let you know
how many times it appears.

To count the instances of 3.7 in the range a1:c3, enter this formula
in an empty cell outside of the range:

=COUNTIF(A1:C3,3.7)

-Jon Crowell
 
Top