OR function that ignores blanks

[PixieS]

Hello,
thank you in advance for all help regarding this.

I am trying to

get
for these purposes - get a function that automatically shows a text (wonderful) or (no good) for a sequence of stats (manually inputted) based on student scores.

I am trying to find out which meet crtieria for certain elements.

Help form an excel friend, advised to split it up, and use the or function:
=OR(H5="<69",H5>20<85)
for the first set, to determine if for example h is meeting criteria, then total all these criteria check, to give an answer. A wrokaround i can live with.


So
col H (data set 1), J (set 2), k + L (need to count of these data set 3), M (set 4). (i have 7 of these that may or may not be filled.

so in AL i have the OR function above =OR(H5="<69",H5>20<85) but it also counts the blank cells. = i then have AM which counts the qualifying columns here, and returns the result which i have copied into column T.

A) any ideas how i can make either the OR function ignore blanks, or make blanks 0, and then it ignore zeros.
or B) how i can get it to count only the cells that meet criteria without a loop /work around?

thanks again

 

[KRice]

Welcome to the Mr. Excel board! I do not completely understand what you want to do in columns K:M and beyond, but here is an example for how to check whether scores in column H meet the criteria described, as well as counting the number that do meet the criteria:

Book1
	F	G	H
2	Count of TRUEs	6
3			Data Set 1
4		Conditions Met	Score
5		TRUE	69
6		TRUE	70
7		FALSE
8		TRUE	68
9		FALSE	99
10		FALSE
11		TRUE	20
12		TRUE	21
13		TRUE	19
Sheet1

Cell Formulas
Range	Formula
G2	G2	=SUM(--(G5:G13))
G5:G13	G5	=AND(OR(H5<>"",H5<>0),OR(H5<69,AND(H5>20,H5<85)))

You may want to check the logic and confirm that you want the OR function with the conditions described...for example, <69 does not necessarily make sense when considered with the other condition (e.g., >20).