Count cell with multiple value

[pjlau]

Dear all,

I have a worksheet with a column contains with the following status code

Status - the status is 04 or 05 or 11 or 12 or 1 number from (either 04 or 05 or 11 or 12) along with 01 or 02 or 03. or 09 or 10 e.g. "02,01" or "01,11"

Is it possible to write a formula to count the "status" column for cell = "11" inculding the number from (either 04 or 05 or 11 or 12) along with 01 or 02 or 03. or 09 or 10 e.g. "02,11" or "01,11" or "10,11"

Thanks & regards

Pjlau



I

[tigeravatar]

pjlau,

Hard to say without an example, but I think what you're looking for is the Countif() formula.

So, to count the number of 11's after the comma, it would be:
=COUNTIF(A1:A10,"*,11")


And, to count the number of 02's before the comma it would be:
=COUNTIF(A1:A10,"02,*")

[pjlau]

Tigeravator,

yeah, this is what I want..

Many thx for your quick rsponse.

pjlau