How To Cell Values By Color in Google Sheets

In this video, I 'll show you how to calculate the values of cells by color in Google Sheets

STEPS:
1. Open your spreadsheet
2. Install the PowerTools Add-on from the G-Suite Marketplace
3. Click Add-on
4. Select PowerTools - Start
5. Click red-underlined Σ.
6. Select Function by Color
7. Select the Source Range
8. Pick the color using "Pattern cell"
9. Select the type of calculation (Sum, Count, Average, etc...)
10. Click Insert Function