Do you need to count or sum cells based on the background color? In this video, I'll show you two custom functions that allow you to do just this in Google Sheets, along with a quick secret to make this easily refreshable. You can make a copy of the Google Sheet that includes both custom functions here: