Sum by color using VBA in Microsoft Excel
In this article we learn to how Microsoft Excel Sheet can calculate the sum of Cell with specific Color in defined range of Cell. we create the custom module by using VBA in Microsoft Excel.
Step 1: Open Microsoft Excel where you want to Sum Cell with specific Color in defined range of Cell
Step 2: Using Keyboard press Alt-F11 to Open Microsoft Visual Basic for Applications
Step 3: User right click on "Project - VBAProject (pane)" select insert and click on "Module (menu item)"
Step 4: Copy the following code in Module1 (Code) (window)" and save and Close the Microsoft Visual Basic for Applications
Step 5: Now select Cell where you want sum and type =SumByColor(referenceCell,SelectRange)
For my Example =SumByColor(E31,H2:H28)
where I want to add red Color Cell and my reference Cell is E31(Sum of Wrong Entry)
Enjoy....