•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
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#COUNTIFS
#TRUE
#COUNTIF
#function
#true/false
#values
#column K
#corrected
#data
#returning 0