This video will demonstrate how to count and sum based on cell background colour using the GET.CELL function. The solution is achieved without using VBA. If you would prefer a VBA solution, please see https://youtu.be/XFpO_q1HJV8

This video will be useful if you are asking the following questions:

How do I count colored cells in Excel using COUNTIF?
How do I count colored cells in Excel without VBA?
How do I sum colored cells in Excel?
What is the formula to count colored cells?
What's the Excel cell color formula?
------------------------