•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
COUNTIFS not recognizing TRUE values
I feel like I’m crazy. I have a simple COUNTIFS function that is returning 0 for every line. At first, the values for column K were lowercase true/false but I’ve struggled with that in the past so I corrected the data to uppercase. No matter whether I use TRUE or “TRUE” in the function, it always returns 0.
I even tried a simpler =COUNTIF(K:K,TRUE) (also tried “TRUE”) and it’s not working either.
What am I overlooking here?
[link] [comments]
Want to read more?
Check out the full article on the original site