Hey there stranger!

Sign up to get access.

3 More Ways to Count in Google Sheets

About this Tutorial

Learn how to use CountBlank() and more counting formulas.

Video Transcript

 Hey, sheet shakers, formula fanatics. Cool. Cats, kittens. Everyone out there is watching. This is three more ways to count in Google Sheets. I previously have a video called Three Ways to Count in Google Sheets, and we went through Explorer, which is a quick view down here when you have some numbers.

Don't even think it's gonna show up here. There it is. Oh, we.  outside of our balance there. There it is. Count. We also have count all count if those are two formulas that I use a lot and I'll show you one other use I use for them. So if I go, I, I use count all, sometimes even when I want to u a unique and I wanna do unique C3 to C and it gets me three.

And if I add a quick view, that's two. Cuz there are only two unique. Things there, but Gucci gives us these count blank. It can count the num. The formula, the actual built-in formula can count the number of blanks in your range. Lemme move my face. And here it shows us in column B, how many blink cells there are.

Right now it's five. There's one up here, and then whoops. One, two. There's actually two up here. And two down here. And then Count Unique gives us a way to literally count all of the uniques in a range. And this is three, because in the column of B, there is three unique. So we can add count, blank and see one is added up here, or sorry, one is taken away because there's one less blank cell and there's still only three.

unique cells here. If we added S, see now that is four. If we delete that, or even if we add it all over the place, unique stays the same. If we override this, that goes down. Now we only have two unique things here, but we have three blank cells. , let me undo a bunch of that. And then we have count ifs, which adds more options or more variables.

Not options, but more variables to count. So we only are counting something. So with count blank we're counting nothing. With counting unique, we're counting everything but only once and count ifs. We're counting only some for some of the things. And here where we have count ifs, if so, now we're only gonna count.

And C, if B is count ifs and C is, hello. So let's go. Hello? And we have one. But if we put hello here and we delete that, we have zero because even though Count Ifs shows up here and hello shows up here, that's what the variable is. It needs to B on the same line. So interesting. , we can use these in a lot of ways.

We can count blank. If you wanna quickly ascertain say how much work you need to do. If you are, if you need to fill in say, a set of like 50 tweets or something. This is actually really funny, okay. I use this oddly enough when I'm writing like tweets and I'm like, Hey, I want to know how many do I have left to.

let me get rid of that. We go, so what I do is, okay, this is, this is like a cheat that I, I use just because I don't want to add a, I don't want to add another row and I don't wanna like really have this number around here so often I just need to get through a certain amount. So I'll go equals count blank, and I'll do B two to B.

And here it says a thousand. But actually we can, we can go up here. And we only want 50 tweets at the, at this moment. And so now we go back up, we have 50. And now as I fill this in, fill this in with tweets, I'm writing, you know, kinds of stuff here, it's gonna count down. Okay? So, , what you might think is like, we need to count how many we've done.

Right? But this is like a little mental trick or a psychological trick that I, I, I play on myself is actually, it makes me finish faster and with more intensity if I count down and I see that progress instead of like, we, we. Normally that like we wanna see a number go up, we wanna be like, okay, we know our goal and we might even do goal equals 50.

And then we are like, we might do how many done, done, and we might do equals count all B two to B. And like, great. Now you're counting up and you have, but you have to know your goal and you know, have to know how many are done. But we can in one number. Just do equals count and blank. I'm like funny enough, within one number, we know everything we need to know, right?

We just need to, no, I, I need to do 47. That is it. That's all I need to do. Okay. And then as I'm doing it, right, we can see that number go down, and then once we get, once we're done right, we can go put that back and it's. And we don't, we don't have to see that number ever again. So that's like a little tiny trick when I'm working through Google Sheets and I'm working through data, doing some data ming or data crunching or something, and I need to figure something out or write something.

This happens a lot. When I have to write, I really need to like trick my brain into saying, okay, just three more then two more, then one more. Okay, we're done. That's really a, a funny use of, of count, blank count. , this is something. Okay. There is one pitfall with this that I will tell you about. I don't like using this actually very much.

I would much, I much prefer doing count all unique B two to B doing something like this. The reason is because, well, I would say the only time you would use Count unique is if you knew. , you, you already knew what the answer was or, or rather, you just don't need to check what is unique. If you know like there's a certain, because here unique is funny.

Here we'll do equals unique B two to B. And if I do this and this, , I think you'll start to see what is the problem

is that even though these two are generally the same, it's that they're not capitalized exactly the same. They end up in different they're different, right? They are not unique. And, but if you do count, if I do this a lot, I want to count. And don't I count this unique F's up a little bit because fill this in is seeing the, these count is counting these, so Count Unique is gonna do the same thing.

B two to B, we have nine unique, right? Because these are the unique ones. But if we just counted. We would not realize that these are the, not the same. This error would persist through this number and we would never be able to find it out. So what I like to do, and this is just a very personal, like best practice, because I've been I, I've had some problems in the past, but I would do unique first.

See, okay, this is the unique fun, these are the unique things that I have. And yes, these are unique. I would even try sorting it.

And see now very clearly you can see this Phyllis in. Phyllis in is the same. Dk. Dk. These are the same and you're like, oh no, my unique messed up so you can catch yourself here. And then I would put on top of this, count on, and so now I would, now I know okay, that nine. But I know the answers in there are messed up, so I know, okay, I need to deal with.

See now D i I fixed these dks and now this is eight. Perfect count. IFS is a little more interest. . And so come ifs is fun because very often you may have multiple ranges or, or rather like columns, like dates or sums or sales figures. Like you want to figure out, you know, who has the most sales or, or some sales above average and revenue above average kind of thing.

This is really, really good to use Count Ifs because you can. Also outliers with this. This is like really good to figure out. And it can go on for a lot too. You can add more than two things here. Count ifs is fun. Count unique is fun count, blank is fun, but they have their places. The other ones that I, I, I talked about before in the other video explorer, call County, if I use.

Religiously. Not every, not, I don't mean just every Sunday. I mean like all the time. I use these all the time. These ones, you know what I would say, probably outta the last three years, I don't use these, but like once or twice, very, very, very few times, I will almost never go back to a sheet. But the count blank one, I, I use sometimes I view that a few.

It's really fun. It, it, it makes it more, more visceral as I'm, as I'm moving through sheets. It's really cool. Thanks so much for watching. I hope, I hope you can find a really cool use case for these kinds of things. Count blank, count unique. Again, absolutely really important that you don't.

get messed up with, with the sort of idiosyncrasies that occur with unique. Also, blank blank is funny because sometimes you do wanna count the actual blanks and you can find that out, like is blank, right? Drew and false. So that happens a lot that I, I use that a lot. Just that is blank. That gives you a true or.

And then you might end up count if here and True could do that as well. So there's a few ways you sort of have to double up. And so Google Sheets has given you a really quick way to do count blank and count unique. Other than doing what I've done, like filtering things and, and, and getting count getting the unique and then getting the count of that filter.

This puts it all into one formula for you, so you can figure that out real quickly. Thanks so much for watching.