Probs with OR nested in COUNTIF function

[50gumbys]

In a spreadsheet we are tracking two types of tasks that people do.
Within a defined range of cells, entries will either be an "I" or a "W".

We want to count the number of times either an "I" or a "W" is entered.

The calculation I thought would do the trick is:
=COUNTIF(Schedule!B11:F11,OR(i,w))

However, I'm getting errors on the OR function.

Using just the letters (I or W), I get a #NAME? error.
If I surround the letters in double quotes, I get a #VALUE! error.

I played with it and found OR accepts numerics.
But that doesn't help me here.

Is there something else I can use to achieve a count?

Thank you VERY much !!
Lori

 

[Brian from Maui]

In a spreadsheet we are tracking two types of tasks that people do.
Within a defined range of cells, entries will either be an "I" or a "W".

We want to count the number of times either an "I" or a "W" is entered.

The calculation I thought would do the trick is:
=COUNTIF(Schedule!B11:F11,OR(i,w))

However, I'm getting errors on the OR function.

Using just the letters (I or W), I get a #NAME? error.
If I surround the letters in double quotes, I get a #VALUE! error.

I played with it and found OR accepts numerics.
But that doesn't help me here.

Is there something else I can use to achieve a count?

Thank you VERY much !!
Lori

Either,

=COUNTIF(Range,Criteria)+(COUNTIF(Range,Criteria)

or

=SUMPRODUCT(--(B11:F11={"I","W"}))

 

[Aladin Akyurek]

Also:

=SUM(COUNTIF(Schedule!B11:F11,{"i","w"}))

 

[50gumbys]

Yippeeeeeee !!!!!!!!!!!!

She works like a store-bought one!

Thank you SO much !!

 

[50gumbys]

Wow!
That's a good one too!!
This is like being in a candy store!!
Thank you!!