Thread: Summing cells within a column based on cell fill color
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Jim D.[_2_] Jim D.[_2_] is offline
external usenet poster
  
Posts: 16
Default Summing cells within a column based on cell fill color
Thank You. Pretty intense for an Excel intermediate, but I'll try to figure
it out.

Jim D.

"Gary''s Student" wrote:

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