Excel: Countifs where a column doe not equal x


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


This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of August 13, 2014.


For more resources for Microsoft Excel