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

[hugo.vanegas]

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

 

[Gord Dibben]

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

 

[Ron Rosenfeld]

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