How to count no. of Cells in MS Excell depending on their Fill Colors

Question

I want to count the no. of cells in a row or column based of their background colors, e.g. how many are Red background, how many are Blue etc in a range of cells

Answer 1

It looks like there are ways to do this, using Excel VBA, but not natively using the COUNTIF function. The COUNTIF function uses the data in the cell as criteria - is there a data criteria in use for determining background color that could also be used for a COUNTIF function?