Learn how to create formulas that sum or count based on the background color of the cells. Due to the comments below, a new video with multiple colors and a checkbox for refreshing the formula was made, and it's here Thanks for letting me know what your questions were. See the following links for the two formulas: See the same subject on the Prolific Oaktree website with a linked Sheet: Use Power Tools for functions by color using a plugin instead of a custom script: 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 🌳 Related Playlist - Google Apps | Full Tutorials - #countif #googlesheets #spreadsheets