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