Countifs where a column doe not equal x

[magpie2000k]

Hi All I have read and read and tried and tried but cant get formula to work.

Basically the below is the written formula

=COUNTIFS(Data!$H:$H,'All Dates'!$B3,Data!$I:$I,'All Dates'!$C$2,Data!$F:$F,'Month select 1'!C16,Data!J:J,"<>Voided")

It all works but I need to exclude from the count Anywhere in column DATA!J:J where the entry is Voided or Possible Void

The formula when you remove that last criteria works and returns the correct number in the count but when I add the last criteria it returns 0 which is incorrect.

Please help

 

[magpie2000k]

So everything is OK. That's great...

yes thanks still struggling with my other post

 

[Aladin Akyurek]

yes thanks still struggling with my other post

What other post?

 

[magpie2000k]

http://www.mrexcel.com/forum/excel-questions/798555-rank-order-staff-not-working.html