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