To COUNTIF By Color Please Follow The Step Shown Below With Images.
- Go To Formula Tab.
- Then Click On Define Name.
- You Will See One Dialog Box Get Pop-Up.
- In Name Bar Please Add Any Name Without Space Ex: CELLCOLOR.
- In Scope Dropdown Please Select According To Your Requirement.
- In Comment Box Add Any Comment To Display On Cell Selection.
- In Refer To Bar Add This Formula =GET.CELL(38,Sheet12!$A2)
- Once This Done Create A Separate Column Called Color Code.
- Apply Formula =CELLCOLOR or Whatever Name you Have Given In Name Bar.
- Once You Have The Color Code You Can Apply Formula On It As Shown In Image Below.
- NOTE: Change Reference According To Your Range & Sheet. This Formula Will Refer To Single Cell In A Sequence Manner.
- Click Ok.
- Please Check Image Below.


