magpie2000k
Board Regular
- Joined
- Sep 13, 2013
- Messages
- 196
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
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