Counting colored cells?

[Zerex71]

Group,

Does anyone know a way if I can do something like a SUMIF() based on
the background color of cells? For example, if I have data and I
color the cells in column individually, and I want to sum the contents
of all the green cells, can I do that? Furthermore, can I do a
COUNTIF() to count the number of cells with a given color?

Thanks,
Mike

 

[Gord Dibben]

If cells are colored due to Conditional Format then use the CF criteria to
count.

If colored manually, you must use a VBA Function.

See Chip Pearson's site for this.

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


Gord Dibben MS Excel MVP

 

[Harlan Grove]

Does anyone know a way if I can do something like a SUMIF() based on
the background color of cells? For example, if I have data and I
color the cells in column individually, and I want to sum the contents
of all the green cells, can I do that? Furthermore, can I do a
COUNTIF() to count the number of cells with a given color?

Learn to use Google Groups search.

http://groups.google.com/groups?scoring=d&as_epq=count+by+color&as_ugroup=*.excel*

which gives the following link on the first page

http://groups.google.com/group/micr..._frm/thread/8e52bc2acc97562c/68e6b8009863672a