Back to Browse

Google Sheets Highlight rows and sum values based on a checkbox

693 views
Nov 24, 2022
11:13

This video demonstrates how to use the check box highlight rows and sum values. You will learn: how to insert checkboxes in google sheets; how to link a check box and the SUMIFS function in google sheets so that it sums values based on the selection in the check box how to highlight rows using conditional formatting and have it link to the checkbox such that the selection in the checkbox determines the rows to be highlighted. You can also watch these two videos for more learning: 1-Google Sheet Query function and filtering using checkbox https://studio.youtube.com/video/SCcMbViKXG4/edit 2-Google sheets -Query Function basics and Filtering data using a dropdown list https://youtu.be/fclWGPN-HP8 #googlesheets #googledocs #exceltutorial #googletutorials #googletutorial #googlesheetstips

Download

0 formats

No download links available.

Google Sheets Highlight rows and sum values based on a checkbox | NatokHD