stat analysis problem

  • Thread starter Thread starter John Doe
  • Start date Start date
J

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
 
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
 
THANKS!
Tim Otero said:
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
Click to expand...
 
Back
Top