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

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-color-in-excel/

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