multiple values in one cell
 

is it possible to put more than one value in an excel cell
and then querie the cell for the different values? Say the
cell has 2 and 4 in the cell and I could do a countif
(a2:a100,2) and countif(a2:a200,4)? separated by commas
will not do it is there a way?

multiple values in one cell
 

Hi
try
=COUNTIF(A2:A200,"*2*")

-----Original Message-----
is it possible to put more than one value in an excel
cell
and then querie the cell for the different values? Say
the
cell has 2 and 4 in the cell and I could do a countif
(a2:a100,2) and countif(a2:a200,4)? separated by commas
will not do it is there a way?
.

multiple values in one cell
 

Thank you Frank!!!!!!!!!
it works for multiple values very well it doen't count single values
but I can overcome that easily by making it an "or" statement or by
adding a "comma zero" to the single #'s

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!