Learn how to SUM or COUNT cells based on their background fill color. This video will walk you through the steps and show you how to use the custom functions that come with your spreadsheet copy. This spreadsheet works for up to four colors and is expandable if you're good enough. There is also a checkbox used to refresh the functions. This video came about from viewer feedback on a more simple spreadsheet shown in this video: • Google Sheets - Sum or...
Brian Wochele's Channel bit.ly/wocheleyt
Spreadsheet used in video bit.ly/countsu... (Make a copy to get it into your Drive)
Use Power Tools for functions by color using a plugin instead of a custom script: bit.ly/pt-FC
This is an affiliate link, and you help to support my channel when you use it.
Learn more from Prolific Oaktree:
🌳 Next Video - Google Sheets | Sort and Filter by Color • Google Sheets - Sort a...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-...
#googlesheets #SUM #COUNT
Негізгі бет Google Sheets - Sum or Count Values Based on Cell Color [Improved]
No video
Пікірлер: 200