View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MSOChick
 
Posts: n/a
Default Sum formula of cells with specific color value

Hello,
I am trying to ceate a SUM formula to add only the green filled
cells in a specified range. I am trying to do it with sum and
cell("color",reference) but I can't seem to be able to find color values. A
formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any help
would be appreciated.

Thanks,
Lia