Excel formula to count cell colour and display sum in another

Closed
markrichardsnz Posts 1 Registration date Wednesday September 18, 2013 Status Member Last seen September 18, 2013 - Sep 18, 2013 at 09:52 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 19, 2013 at 01:20 AM
I have had a look through the other questions and responses, but they don't really help. Using Office 2010, I would like to apply a formula to a range of cells, that will add up the number of red, green or orange cells, and display this as a SUM in another cell. The cells that I am 'counting', have conditional formatting formulas in them which relate to other spreadsheets within my workbook. The colour of the cells will alter depending on the information in the source spreadsheet, and instead of me putting a number in each cell and then adding up these numbers using a SUM formula, which I would need to manually alter each time a cell colour changes, I would like it to occur automatically when the source data is amended. HELP.
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 19, 2013 at 01:20 AM
in xl2010 I think built I formula sre there for this
make google searach
one example
https://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html
0