FG
💻 Software

Using excel, how can I count the number of cells in a column containing the text "true" or "false"?

Fresh5 days ago
Mar 15, 202633889 views
Confidence Score0%
0%

Problem

I have a spreadsheet that has a column of cells where each cell contains a single word. 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. In the above spreadsheet table, I have these formulas in cells B…

Error Output

=COUNTIF(A1:A5,"apples")
=COUNTIF(A1:A5,"true")
=COUNTIF(A1:A5,"false")
=COUNTIF(A1:A5,"oranges)

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Using excel, how can I count the number of cells in a column containing the text "true" or "false"?

Low Risk

The second argument to the COUNTIF formula is interpreted by Excel as a test to be performed (e.g. we can enter ">3", etc.). In this case, it looks like Excel is converting the "true" and "false" strings to 1 and 0. That won't match the original tex…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment