Thread: Ignoring highlighted cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
frustrated
 
Posts: n/a
Default Ignoring highlighted cells

Thanks for this info. But I cant get it to work.

I am using the function SUMPRODUCT(--(ColorIndex(A1:A100)=3),A1:A100)

Do I need to substitute a number for --

Also does this work if cells in the column have a few different colours


--
frustrated
------------------------------------------------------------------------
frustrated's Profile: http://www.excelforum.com/member.php...o&userid=27778
View this thread: http://www.excelforum.com/showthread...hreadid=493442

Reply With QuoteReply With Quote