stat analysis problem

Giganews Newsgroups
Subject: stat analysis problem
Posted by:  John Doe (alwa…@in.style)
Date: Wed, 15 Oct 2003

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

Replies