Summing cells within a column based on cell fill color
 

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.

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.

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.