Count and Sum cells with certain format (e.g. color)
 

Im in the U.S. Navy and needed to count and sum a worksheet full of
peoples names whose cells are color coded to indicate where that person
is. There are about four colors which i am trying to sum, is there a
certain built in excel function that can do this, or will I have to
resort to some VBA? If so could you provide some sample code....I am
so stumped.. Thanks

Count and Sum cells with certain format (e.g. color)
 

If the cells are colored due to Conditional Formatting, use the conditions to
count or sum.

If manually colored, you will need VBA.

See Chip Pearson's site for code.

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


Gord Dibben Excel MVP

On 7 Nov 2005 17:34:32 -0800, wrote:

Im in the U.S. Navy and needed to count and sum a worksheet full of
peoples names whose cells are color coded to indicate where that person
is. There are about four colors which i am trying to sum, is there a
certain built in excel function that can do this, or will I have to
resort to some VBA? If so could you provide some sample code....I am
so stumped.. Thanks

Count and Sum cells with certain format (e.g. color)
 

On 7 Nov 2005 17:34:32 -0800, wrote:

Im in the U.S. Navy and needed to count and sum a worksheet full of
peoples names whose cells are color coded to indicate where that person
is. There are about four colors which i am trying to sum, is there a
certain built in excel function that can do this, or will I have to
resort to some VBA? If so could you provide some sample code....I am
so stumped.. Thanks

You will have to use VBA for this.

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


--ron