sum cells by background color (I don't have SUMIFCOLOR)

[Deb Howerton]

How do I sum cells in a certain column with a certain background color?

[#2]

Hi Deb,

Here are a couple of links which can give an idea of how to approach the task using 'Filter by Colour' functionality. The advantage of the method is that it is quick and easily understandable

https://a4accounting.com.au/summing-coloured-cells-in-excel/

https://www.techrepublic.com/blog/microsoft-office/an-easy-way-to-sum-values-by-a-cells-background-c...

If you do not wish to have filters, you can either add an extra helping column or use VBA. Here is the link with a good overview of the approaches: https://www.exceltrick.com/how_to/sum-cells-based-on-background-color/

Thanks

Yury 

[#3]

Hi Deb,

Please test my answer to this question, I think that this is what you want!

I hope that helps

Haytham