•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
COUNTIFS not recognizing TRUE values
Our take
Are you frustrated by COUNTIFS not recognizing TRUE values in your spreadsheet? You're not alone. Many users encounter this puzzling issue, often stemming from data formatting or logical mismatches. When COUNTIFS returns zero despite your efforts to correct the data to uppercase TRUE, it can feel like you're losing your mind. Understanding how Excel interprets logical values is key to resolving this. Keep reading to uncover the common pitfalls and gain clarity on how to ensure your COUNTIFS function works as intended.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- COUNTIFS not working correctly and I'm just confused on what to do.I am trying to learn the COUNTIF formula. =COUNTIFS($S$13:$S$61, ">=95", $S$13:$S$61, "<=97") The function counted that there are 2 that fills this criteria; however, I counted it manually and there should be 3 instead. The same goes for other formulas I inputted. I watched Youtube tutorials and read online forums but I still don't get what is wrong with the function. I use Excel 2019. What can I do to improve or solve it? https://preview.redd.it/z08fpbj2olpg1.png?width=442&format=png&auto=webp&s=fb7eeedffeb55ef7649733465c3006b029b9de1b submitted by /u/LoveMilfsEveryday007 [link] [comments]
- Countifs resulting in #VALUE! with error “A value used in the formula is of the wrong data type.”I’m trying to put together a presentation for a valet company and I’m looking to see how well we perform during peak hours. I have a column for when a vehicle is checked in(column i) and another column for how long it took to retrieve the vehicle(column AJ). I’m using countifs(i3:i2000, “>=06:45”,i3:i2000, “<8:00”,aj3:aj2000, “<00:10:00”) and it results in the problem in the title. I can do a separate countifs for the i column with the time range above and get a numerical result(65) and another countif for the aj problem and get a numerical result(500) but when combining the two I get the #VALUE! error. What am I doing wrong? submitted by /u/R0BZ1LLA [link] [comments]