View Single Post
  #2  
Old May 24th, 2010, 08:22 AM posted to microsoft.public.excel.worksheet.functions
FSt1
external usenet poster
 
Posts: 2,788
Default sum the color cells

hi,
you have xl07 or higher, you are suppose to have this capability already.
see help. i am having research trouble confirming that. if you have xl03 or
earlier, see this site....
http://cpearson.com/excel/colors.aspx

regards
FSt1

"reza" wrote:

hi all.

i have data with different color.
i one column i have 3 color, blue, yellow and red.
now i want to count & sum based on the colors.
how to create formula for that?

many thanks...

reza