Thread: Summing cells within a column based on cell fill color
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Summing cells within a column based on cell fill color
See:

http://www.cpearson.com/excel/Colors.aspx


--
Gary''s Student - gsnu200806


"Jim D." wrote:

I'm trying to sum cells within a single column based on the cell fill color.
There will be a maximum of three individual colors. I'm assuming this
something with either the SUMIF or SUMIFS function, but can't quite get there.

Thanks,

Jim D.
Reply With QuoteReply With Quote