having trouble with OR in COUNTIF statement

[H28Sailor]

I am able to use the following with a single criteria but something is wrong when I introduce the OR statement

=COUNTIF(Y$2:Y$64,OR( "7 *", "8 *", "9 *"))

What am I doing wrong?



Bob M

[xor]

Wildcards only work for cells containing text, not for cells containing numbers.

You might want to try:

=SUMPRODUCT((--(LEFT(Y2:Y64,1))=7) + (--(LEFT(Y2:Y64,1))=8) + (--(LEFT(Y2:Y64,1))=9))

[H28Sailor]

tried the above but get #VALUE!

Fields contain:-

7 Very Hard
8 Very Hard
9 Very Hard

[xor]

I misread your question - thought that your cells contained numbers. If they contain text strings (as per your examples) you can use:

=SUM(COUNTIF(Y2:Y64,{"7*","8*","9*"}))

[H28Sailor]

Many thanks

Bob M