Sum cells by color of cells in Excel

Описание: A way to sum cells based on the color of the cell WITHOUT using VBA.

------------------------------------------------------------------------------------------------------------------------------------------------------

✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Summing all the red cells
00:10 Filter by colors
00:27 SUM, COUNT, AVERAGE only the filtered section
00:54 Sum by the green cells
01:10 Use AGGREGATE to only calculate the visible (colored) cells