Just delete it (the comma) from the formula!

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

What happens with the different column? what is your "new" formula?


"Chart_Maker_Wonderer" wrote:

if the formula you gave me was:

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

Where would I get rid of the extra ","

For the Monitor I have more conditions that i do not want the line to be and
I was just duplicating what you had and it was working until I got to a
different column.


"Toppers" wrote:


There was a typo im my formula .. an extraneous "," in the second parameter
{"Good Keyboard,"} but if I have the following in A2:B7

A3="Good Monitor"
B4="Good Keyboard"
B6="So so keyboard"

I get a result of 3 i.e. Rows 2,5 and 7 are blank

Is this correct?



"Chart_Maker_Wonderer" wrote:

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")