I am currently trying it and it looks like it will only return the number of
times that the conditions are matched in the first column of calculations.

"Toppers" wrote:

If all entries are blank for "n" rows you will get "n" as an answer.

Why not try it?

"Chart_Maker_Wonderer" wrote:

Will that produce a result that if I put that in a spreadsheet and if there
are 5 rows that do not have any of the stuff I am putting into the formula it
will return a value of 5?

"Toppers" wrote:

Look at SUMPRODUCT:

=SUMPRODUCT(--(a5:a7<"Good
Monitor"),--(b5:b7<"Good Keyboard,"),--(B5:b7<"So So Keyboard"))

The -- coercises the TRUE/FALSE conditions to 1/0.

HTH

"Chart_Maker_Wonderer" wrote:

Is there a way that I can use OR and NOT statements in Countif statements?

I am working on an inventory sheet where it will count how many stations do
not working.

To determine that the station is good I have some different text, and if the
station is not working I have other text the person can type.

What I would like to do is to have Countif(a5:a7<"Good
Monitor",b5:b7<"Good Keyboard,B5:b7<"So So Keyboard")