Ken Asks: How can I count true and false? Answer: w/ CountIF()

Beginner

About this Tutorial

the answer is if you have a column of true or false you can use the count if statement argument formula. That's just count if, and then you say your range, and then comma, true. Or false, whichever one you want and you'll get a count.

Sheet Resources

Access Sheet

Copy Sheet

Preview Sheet

Featured Formulas

COUNTIF()

Video Transcript

<div> Hey, Ken was asking how can I count true and false or tr true or false? And the answer is if you have a column of true or false you can use the count if statement argument formula . That's just count if, and then you say your range , and then comma, true. Or false, whichever one you want and you'll get a count. But if you notice, I have all these truths down here and I've used lower with quotation marks in true. And it's not counting them. So it's not counting the word true. And even if I it like knows that the term true should be all caps true.

So the, so when you type in let's do this true. When you type in true, it actually redos it as all caps true. And it doesn't count all lowercase true. Even if I put it in legal's lowercase. And even if I put as the argument over here, this lowercase true, it's not counting it in the formula . It thinks that all lowercase true is all uppercase true. And it's a bullying statement, which is true or false or one or zero. Very interesting pitfall you might run into. If you have text somehow. If you have the text true in all lowercase, it won't be counted.

If you have true or false, it will be counted even if you use all lowercase true and you count if you can also, instead of writing the word true or false, here you can say equals count if put in the range . and put in G one. So now it's counting this and you can just put true there. You can also put false and now you have a counting. You can make a nice little table here. Count of true false. One other thing I will mention with true or false, let me delete these.  Is, it's a checkbox , or you can use a checkbox here and check boxes are only true or false.

So if I go, if I, if I have all of this true or false, and I highlight them and I go insert checkbox , it automatically knows that True is a checked checkbox . And false is a unchecked checkbox . So I'm gonna undo that. And if I have, let's say I'm gonna insert check boxes here.  and I want to say, okay, count from here. True or false? Like this might be some data . We want to check it, right? Who you will do. We're gonna delete this one and do count and do true and false, and then I'm gonna go equals count. And I'm gonna do this range here.

One, all the trues and parenthesis, and now we have zero. And how many falses we have? Nine. So you could also use a checkbox as a true false statement here, and you can use them in interoperably meaning you can replace them with each other. So if you already have a column of truths and false.  You can replace it with check boxes to make it one click. True or false. And if you have, if you have, oh, this is interesting. If you have a check boxes already and you want to change them, if you just through equals now they're all, oops.

Now you have a true false from a checkbox programmatically. So you can change this to check. And that's true. Check true. True. And so you can use these true false statements interoperably, with check boxes as well, and then count check boxes as in the same way. Check count true, count, false in with a count if formula . And that's how you can count true and false. And you can also do something extra with, with check boxes by.</div>