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