Microsoft Office Forums - View Single Post - having trouble with OR in COUNTIF statement

Thread: having trouble with OR in COUNTIF statement

View Single Post

Old

07-28-2016, 09:03 PM

H28Sailor

H28Sailor is offline

H28Sailor uses Windows 7 32bit

Windows 7 32bit H28Sailor uses Office 2007

H28Sailor uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: Mar 2013

Posts: 55

H28Sailor is on a distinguished road

Default

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

Reply With Quote