ExcelBanter - Sum cells in different colors

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum cells in different colors (https://www.excelbanter.com/excel-discussion-misc-queries/31714-sum-cells-different-colors.html)

heater

Sum cells in different colors

Can you sum all the numbers in a column that are green only? I do not want
to sum numbers in other colors.

Chip Pearson

You need a VBA macro to do this. See
http://www.cpearson.com/excel/colors.htm ,

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"heater" wrote in message
...
Can you sum all the numbers in a column that are green only? I
do not want
to sum numbers in other colors.

All times are GMT +1. The time now is 02:25 PM.