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.