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




About this tutorial:

Video duration: 00:10:54
Learn how to write an Excel formula to sum values based on the cell background color.
Link to the complete course:

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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads