SUMIF By Cell Background Color In Excel
To SUMIF By Color Please Follow The Step Shown Below With Images.
Go To Formula Tab Bar.
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 Upon Cell Selection.
In The Refer To Bar Box Add The Formula =GET.CELL(38,Sheet12!$A2)
Once Done Then Create A Separate Column Heading Called Color Code.
Apply Formula =CELLCOLOR or Whatever Name You Have Given In Name Bar.
Once You Have The Color Code You Can Apply Any Related Formula On It.
NOTE: Please Change Reference According To Your Range & Sheet. This Formula Will Refer To Single Cell In A Sequence Manner.
Click Ok.
Please Chec...