ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What formula can I use to sum only certain colored cells in an exc (https://www.excelbanter.com/excel-worksheet-functions/69948-what-formula-can-i-use-sum-only-certain-colored-cells-exc.html)

Favi

What formula can I use to sum only certain colored cells in an exc
 
Based on a grading system I have color coded certain cells in matrix excel
sheet and I only want to add certain color coded amounts with a formula
instead of going in manually and adding it one by one. Is there any formula
for this??

CLR

What formula can I use to sum only certain colored cells in an exc
 
http://www.cpearson.com/excel/colors.htm

Vaya con Dios,
Chuck, CABGx3



"Favi" wrote in message
...
Based on a grading system I have color coded certain cells in matrix excel
sheet and I only want to add certain color coded amounts with a formula
instead of going in manually and adding it one by one. Is there any

formula
for this??





All times are GMT +1. The time now is 09:00 PM.

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