How do I count in Excel?
 

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.

How do I count in Excel?
 

Hi
=COUNTIF(A:A,3.7)
for column A

--
Regards
Frank Kabel
Frankfurt, Germany

"Steven" schrieb im Newsbeitrag
...
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.

Thanks very much.
 

-----Original Message-----
Hi
=COUNTIF(A:A,3.7)
for column A

--
Regards
Frank Kabel
Frankfurt, Germany

"Steven" schrieb
im Newsbeitrag
...
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.

.

How do I count in Excel?
 

"Steven" wrote in message ...
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.

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