May 08 2020 06:32 AM
I am trying to add up certain cells that I highlight in a spreadsheet.
I thought several years ago I could do that with a Sum By Color formula, but it no longer works.
Especially in updated excel.
Can you assist?
May 08 2020 08:19 AM
@JoniWeise I suspect that you had a User Defined Function on your system before updating Excel. Similar to what you find in the attached link.
https://www.exceltrick.com/how_to/sum-cells-based-on-background-color/?
To my knowledge, SumByColor has never been a standard Excel function.