View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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