COUNTIF Formula with DOES NOT EQUAL TO operator doesn't work

C5 - C52 have either the following values: Pass, ADD, DNE, IC, CORR, or IE.

In that specific range, I wanted to count how many times it IS NOT a Pass.

This is the following formula I currently have: =COUNTIF(C5:C52,"<> Pass")

However, it doesn't work because the value that I get is 48, which is the total range.
Am I doing something wrong?

As a side note, C5, C6, C7, etc. all are merged cells (C5 is merged with D5, C6 is merged with D6, etc.)

Try it without the space between > and P

Hope this helps.

Pete

Yes, both of you are right. It did work.

Now I need to do just one more count if but it needs to meet 2 criteria.

1. A row is USUALLY 1 widget. If the next row has the same widget, then it can't count it again.
2. In a range of cells (2 columns), if its blank on both of the rows, then it can't count the widget.

How do I put in the COUNTIF Formula

=COUNTIF(the widget row, the widget above it can't be the same widget name AND if they aren't the same, count them only if the corresponding row in columns L & M ARE NOT BLANK)

Is it: COUNTIF(B5:B52, L5:M52<>" "" B5<>B6 (note: I forgot what was the array symbol))?

Ace... almost there. I tested it. I do get the correct total that I'm looking for, but for the wrong reason.

Lets say Widget 26 is in row 26. Since L26 and M26 are populated, it counts it.
If EITHER L26 or M26 are NOT POPULATED, then it wont count it.

What I need the formula to say is that it will not count Widget 26 ONLY WHEN L26 AND 256 are not populated.
If either L26 OR M56 are populated, then its ok... it CAN BE counted.

In simpler terms


Column B Column L Column M
---------- --------- ----------
Widget 24 ABC ZZZ - Count the cell (L24 & L25 are populated)
Widget 25 345 - Count the cell (L25 is populated)
Widget 26 ??! - Count the cell (M26 is populated)
Widget 27 - DON'T COUNT the cell (L27 & M27 are not populated)
Widget 28 abc - Count the cell (L28 is populated)
Widget 28 - Already counted, so no need to count it
Widget 28 abc - Already counted, so don't count it again.

Hey, it removed my spaces! I hope you guys can understand what I was trying to say.

Why don't you just attach a workbook - then we can see what you are trying to describe.

Pete

Here you go.
Check it out.

SOLVED!

daddylonglegs... At first it didn't work, it gave me the #value error but I forgot to array it.

Why does array'ing it make it work?

Interesting... thanks Tony.

Originally Posted by Pete_UK

Try it without the space between > and P

Hope this helps.

Pete

As I am using it now, I forgot (my fault) to add one scenario. If the cell is blank, don't count it at all.
This is concerning the first function I had trouble with... =COUNTIF(C5:C52,"<>Pass")

Thanks. That did the trick.
I never heard of COUNTIFS before.