View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default conditional sum ??

I have a simple formula...
=SUM(C61:AY61)
The cells represent open slots in a fiber switch. some of the cells are
colored gray to represent no hardware installed for that slot. is there a way
to have the formula only add the cells that are not gray? I didnt see any
color options in conditioanl formatting.

Thanks