ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   column addition question (https://www.excelbanter.com/excel-worksheet-functions/72654-column-addition-question.html)

D

column addition question
 
I am a column that has the numbers in color, is it possible to add the
numbers together by color, i.e. all red,all blue? If so what would the
formula be.

Thanks

Chip Pearson

column addition question
 
There is no way to do this with a worksheet function. You need a
VBA function. See http://www.cpearson.com/excel/colors.htm .


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


"D" wrote in message
...
I am a column that has the numbers in color, is it possible to
add the
numbers together by color, i.e. all red,all blue? If so what
would the
formula be.

Thanks





All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com