How to SUM Cells by Color in Excel (Get it to update automatically)

How to SUM Cells by Color in Excel (Get it to update automatically)

 

Learn how to write an Excel formula to sum values based on the cell background color. We achieve this with a simple Excel VBA function. The VBA function has two arguments. One is for color and the other the range that needs to be summed. 

 

You can use a similar technique to count cells based on color.  We also improve on the VBA code to have the formula results update automatically when a cell color in the range changes. This is done by using the worksheet selection change event for a specific range. We achieve this with the Application.Intersect method.

Related Topics:

• Compare Multiple Lists with a Pivot Table
• Introduction to Pivot Tables Part 2 
• PivotPal Guide - The Pivot Table Field List and Selecting Multiple Items
• PivotPal Guide - Filter Source Data Sheet for Excel Pivot Table