ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum cells based upon color of text (https://www.excelbanter.com/excel-worksheet-functions/240794-sum-cells-based-upon-color-text.html)

Jessop

sum cells based upon color of text
 
Can you omit cells purely based upon the color of text when doing
this: =SUM(A2:A38)

Eduardo

sum cells based upon color of text
 
Hi,
yes you can look into CPearson web

http://www.cpearson.com/excel/colors.aspx

if this helps please click yes, thanks

"Jessop" wrote:

Can you omit cells purely based upon the color of text when doing
this: =SUM(A2:A38)



All times are GMT +1. The time now is 06:02 AM.

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