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 .">
Most valuable professional
  • Hot Topics

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel