I'm not going to lie, this trick blew my mind. Have you ever needed to
count or sum cells based on the color of the cell? I've always done a
filter by color, and then created a new column with some sort of key as
to whether to include it in my calculations. Well, someone much smart
than I am created a macro that creates a new function: COLORFUNCTION.
Enjoy!
http://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html
Search terms and phrases:
Excel count based on color
Excel sum by cell color
No comments:
Post a Comment