SUMIF By Cell Background Color In Excel

To SUMIF By Color Please Follow The Step Shown Below With Images.

1. Go To Formula Tab Bar.
2. Click On Define Name.
3. You Will See One Dialog Box Get Pop-Up.
4. In Name Bar Please Add Any Name Without Space Ex: CELLCOLOR.
5. In Scope Dropdown Please Select According To Your Requirement.
6. In Comment Box Add Any Comment To Display Upon Cell Selection.
7. In The Refer To Bar Box Add The Formula =GET.CELL(38,Sheet12!$A2)
8. Once Done Then Create A Separate Column Heading Called Color Code.
9. Apply Formula =CELLCOLOR or Whatever Name You Have Given In Name Bar.
10. Once You Have The Color Code You Can Apply Any Related Formula On It.
11. NOTE: Please Change Reference According To Your Range & Sheet. This Formula Will Refer To Single Cell In A Sequence Manner.
12. Click Ok.
13. Please Check Image Below.

• Share on Facebook
• Share on Twitter
• Share on Pinterest
• Share on LinkedIn
• Share via Email
• Share on Tumblr
• Share on Reddit