Download the featured file and get the code here: https://www.bluepecantraining.com/countif-sumif-on-colour-using-vba-custom-function/ This video demonstrates how to sum and count based on the background colour of a cell. The solution uses custom VBA functions. If you would prefer a non-VBA solution, please see https://youtu.be/8FyyXMC9Jdo

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

How do I count colored cells in Excel with VBA?
How do I count colored cells in Excel (using formula)?
How do I count by colour using Excel macro?
How do I sum colored cells in Excel?
How do I sum by colour in Excel?
How do I sum if cell is a particular colour?
What is the sum by color function code?
------------------------