stat analysis problem

[John Doe]

et al,

Here is the problem I'm having.

I have a column of data (say column 'b') that has numbers in it. both in
the format of '5' '98' '444' etc. What I'm trying to do is come up w/ a
formula that will tell me the number of occurrences in that column of any
number. i.e.. say 5. when I would do count on the above I get an answer
of 3 ( =count(cell1:cell2,5). Or even in the formula when I put the 5 in as
'5'.

Is there a way to do this in excel?

TIA.
-JD

 

[Tim Otero]

The COUNT function counts the number of cells with containing a number...any
number. This is why the formula is returning 3. All three cells contain
numbers.
What you need is COUNTIF(cell1:cell2.5)

tim

 

[Jerry W. Lewis]

Change the period to a comma for US settings.

Jerry

 

[John Doe]

THANKS!

The COUNT function counts the number of cells with containing a number...any
number. This is why the formula is returning 3. All three cells contain
numbers.
What you need is COUNTIF(cell1:cell2.5)

tim

in

 

[Tim Otero]

Oops, typo on my part...Thanks Jerry

tim

Change the period to a comma for US settings.

Jerry