Thread: Sum Cells Based on Color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Sum Cells Based on Color
see:

http://www.cpearson.com/Excel/colors.htm
--
Gary''s Student - gsnu200768


"Sherry N." wrote:

Hello,
I need to sum cells on sheet1 from sheet2 that have no fill or white
background.

In a cell on Sheet1 I used:
=SUMPRODUCT(--(ColorIndex('Sheet2'!C:C)=2),'Sheet2'!C:C)

But it didn't work. Any help?

Thanks,
Sherry N.
Reply With QuoteReply With Quote