having trouble with OR in COUNTIF statement

		Microsoft Office Forums > Microsoft Excel > Excel
having trouble with OR in COUNTIF statement

FAQ

Thread Tools

Display Modes

H28Sailor having trouble with OR in... 07-28-2016, 09:03 PM

xor Wildcards only work for cells... 07-28-2016, 09:59 PM

H28Sailor tried the above but get... 07-28-2016, 10:05 PM

xor I misread your question -... 07-28-2016, 10:33 PM

H28Sailor Many thanks :) Bob M 07-28-2016, 11:01 PM

07-28-2016, 09:03 PM

H28Sailor

Windows 7 32bit having trouble with OR in COUNTIF statement

Office 2007

Advanced Beginner

Join Date: Mar 2013

Posts: 55

having trouble with OR in COUNTIF statement

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

« Previous Thread | Next Thread »

Similar Threads
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
COUNTIF Formula	teza2k06	Excel	3	02-13-2014 12:37 PM
Countif	hockeytown	Excel	3	01-05-2013 08:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:00 AM.