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

Posted by Jay Elston on Stack Overflow See other posts from Stack Overflow or by Jay Elston
Published on 2010-05-09T22:48:57Z Indexed on 2010/05/09 22:58 UTC
Read the original article Hit count: 204

Filed under:

excel

|

not-programming-related

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 the above spreadsheet table, I have these formulas in cells B1, B2, B3 and B4:

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

As you can see, I can count apples, but not true or false. I have also tried this:

=COUNTIF(A1:A5,TRUE)

But that does not work either.

Note -- I am using Excel 2007.

© Stack Overflow or respective owner

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More

Related posts about not-programming-related

Webshop software for your existing website [closed]

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I know it's not programming related, but I just wanted to try my chances here... I'm searching for software which can integrate a webshop into an existing website. The most software is a standalone version or a module for some kind of CMS. Can anyone help me? I have a css/div based website… >>> More
Let other computer view my localhost over a network...

as seen on Server Fault - Search for 'Server Fault'
Hi, I have apache and what not running on my local machine (mac), there also another mac on the local network. How does this other machine access my localhost? For example I have a local website at example.local.net in my vhost. How can another computer on the network navigate to this site? Cheers… >>> More
how to download all links at once..

as seen on Super User - Search for 'Super User'
hello friends,i want to ask u ..is there any software..that download all the link at once.. like e.g. in w3school.com. if we want to download all the php tutorial at once.someone has told me "tglepote".bt i am getting on the google.plz help >>> More
Textmate quick one

as seen on Super User - Search for 'Super User'
I know its not strictly programming related, but the textmate mailing list is too 1990 for me to use properly. I won't make a habit of this: Anyone seen this popup before, it happens everytime I boot my mac. If so how do I kill it? Thanks. >>> More
On the lighter side : 'sudo apt-get moo' or a treatise on Ubuntu Cows !

as seen on Super User - Search for 'Super User'
While dabbling about Ubuntu 9.10 ! I came across this command ! ..... sudo get-apt moo acer@acer:~$ sudo apt-get moo (__) (oo) /------\/ / | || * /\---/\ ~~ ~~ ...."Have you mooed today?"... Which most surprisingly 'made a MOO' ! .....Does anyone know any more… >>> More