👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you! 👍👍
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?
------------------------