So you want to count checkboxes. Well, we need checkboxes to begin with. Let's highlight where we want those checkboxes and insert checkbox . Now let's say we have some things that are approved, that are reviewed, that are completed. And we want to count these. We want to insert a row up here. And let's just count how many are checked. We use count if D3 coliteria just true. So a checkbox is just going to be the value of true or false. So we're just going to count tr. I'm going to show you one other way you can do this and it's a really fun sort of way to see more of what's happening in Google Sheets. So in this checkbox I'm going to rightclick view more cell actions go to data validation and in this checkbox it says criteria checkbox. I'm going to check here where it says

use custom cell values and instead of true I'm going to put a one and instead of unchecked I'm going to put a zero and hit done. Now you'll notice nothing happened because all of these checkboxes are still checkboxes. It's either going to be checked or not checked. One thing that did change is our count if is counting true. I'm actually going to use sum. D3 col d. And now using sum, I have the same exact count, but I'm only using the sum formula because each of these values is either one or zero. And as you see, we can check off a few more and the number keeps going up. So, I think that's pretty fun fun way to use checkboxes in Google Sheets.

You're watching Better Sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how-tos, get more out of your Google Sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is going to be your next Google Sheet.