Counting Text

  • Thread starter Thread starter locutus243
  • Start date Start date
L

locutus243

I have a list of text (e.g:-

True
False
True
True
False

I want the cell which will count how many times False appears in thi
column of cells. I assume its a fairly easy function but I dont kno
which one!!

Cheers

Mar
 
If it's really text--not boolean TRUE/FALSE, then how about:

=sumproduct(--(a1:a1000="false"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Count by Colour (Text) with other criteria 2
Boolean Values in Pivot Table 1
Help using Chip Pearsons code to count cells with color 9
counting unique values of text 4
Howdy! Need a little help with code... 3
Function for "Contains" 5
Changing Text To Numbers ? 1

Back
Top