ExcelBanter - SUMIF Based On Cell Color

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

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

- - SUMIF Based On Cell Color (https://www.excelbanter.com/excel-discussion-misc-queries/199273-sumif-based-cell-color.html)

Mike

SUMIF Based On Cell Color

I have set certain cells in a column to be certain colors. These cells have
not been conditionly formatted. Is there a way to sum the cells based upon
their color?

FSt1

SUMIF Based On Cell Color

hi
see this site..
http://cpearson.com/excel/colors.htm
has a number of functions that sum by color, count by color ect.
if you have 2007, i have heard that this functions are now built in.
(i've heard but do not know)

Regards
FSt1

"Mike" wrote:

I have set certain cells in a column to be certain colors. These cells have
not been conditionly formatted. Is there a way to sum the cells based upon
their color?

All times are GMT +1. The time now is 04:35 PM.