Counting colored cells?

  • Thread starter Thread starter Zerex71
  • Start date Start date
Z

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
 
Zerex71 said:
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?
Click to expand...

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
 
Back
Top