Summing cells within a column based on cell fill color

  • Thread starter Thread starter Jim D.
  • Start date Start date
J

Jim D.

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.
 
Thank You. Pretty intense for an Excel intermediate, but I'll try to figure
it out.

Jim D.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
SUMIF non-blank cells? 5
Function for summing or counting cells based on a specified fill color 2
How can I sum numbers that have a gray color-fill in cell? 1
Summing Cells by Color 5
A UDF for Counting Coloured Cells that are conditionally formatted 5
Sum Column Based on Cell Color 5

Back
Top