Average Only Checked in Google Sheets
Learn how to calculate the average of only checked items in Google Sheets using checkboxes and the FILTER function. This tutorial also covers how to handle errors when no checkboxes are selected.
Okay, so we wanna average only check. So if we have some data here, we wanna add some check boxes and we only wanna average those particular items. Here we have some citing locations, a creature and a credibility score. We don't want to just say equals average D two colon D, which would be a average of 56 credibility score. Here we want to only check some. So let's go over to the A column. Let's insert some check boxes. There you go. And let's say we want to just do Bigfoot, Yeti, and Wingo. Now those are three items checked off over here on our average. Let's delete that. Magical Things You Can do with Checkboxes in Google Sheets How To Hide Data with Checkboxes in Google Sheets Average Without Zeros in Google Sheets
Let make it nice and green. Maybe we're gonna do equals filter and we're gonna filter the D column. What is the condition ? Well, the A column equals true. And if we just do this alone, we see the numbers. 82, 35, 88. Now this allows us to see, okay, we're on the right track. We got all those numbers. Now just average them, so just wrap average around that filter . And we got the average only for the check boxes. So that'll change as I check these boxes. One issue will be, if I have nothing checked, I'll get an a. An error , which sometimes people don't like to see that. So right between average and filter wrap around the filter. Magical Things You Can do with Checkboxes in Google Sheets How To Hide Data with Checkboxes in Google Sheets Enter Name Get Grades
If NA and I like to go over here to the other side and do a comma, nothing, just comma and then end parentheses and we'll get zero. You are 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 gonna be your next Google sheet. Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets. Absolute Basics of Google Sheets YOU CAN DO BETTER