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?

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?
.

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!