![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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)) |
#3
|
|||
|
|||
![]()
tried the above but get #VALUE!
Fields contain:- 7 Very Hard 8 Very Hard 9 Very Hard |
#4
|
|||
|
|||
![]()
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*"})) |
#5
|
|||
|
|||
![]()
Many thanks
![]() Bob M |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with IF and COUNTIF functions | jester296 | Excel | 1 | 05-13-2015 09:09 AM |
Countif statements | Alaska1 | Excel | 5 | 02-05-2015 07:55 PM |
CountIF Functions | Alaska1 | Excel | 4 | 01-30-2015 09:59 AM |
![]() |
teza2k06 | Excel | 3 | 02-13-2014 12:37 PM |
Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |