Using excel, how can I count the number of cells in a column containing the text "true" or "false"?
- by Jay Elston
I have a spreadsheet that has a column of cells where each cell contains a single work. I would like to count the occurrences of some words. I can use the COUNTIF function for most words, but if the word is "true" or "false", I get 0.
A B
1 apples 2
2 true 0
3 false 0
4 oranges 1
5 apples
In…