How to Count and Sum Cells by Color in Excel

Today I want to share with you an excellent and useful macro I found on Ablebits.com, an excellent resource for Excel tools and add-ins. What I like about this macro is that, though the code is long, the function is very simple.


I was creating a budget with color-coded cells and I wanted to sum only the colored cells. The macro I found not only lets you sum and count by the cell color but also sum and count by the font color in the cell.


The macro was written by Svetlana Cheusheva, a member of the Ablebits Add-in Express team. If you click on Svetlana's name in the preceding sentence you can not only learn more about her background but also see the extensive number of posts she has written.


You can find the macro by clicking here. I hope you find it as useful as I have.

2 views