View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ashley Ashley is offline
external usenet poster
 
Posts: 71
Default Can I Sum by Cell Colour or Format?

I have a large list of values, these values have been colour coded. I would
like to sum each of the colours seperately. I know i can add a filter, sort
by colour & sum this for each coulour, but am wondering if there is a formula
that would do this for me?