Скачать или смотреть Excel COUNTIF & SUMIF On Colour - No VBA Required

👍👍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...
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    • COUNTIF and SUMIF on Cell Colour Using VBA...  

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?
------------------------