Forum Discussion
Sumbycolor
I am trying to sum by color across multiple sheets.
I currently have,
example:
=sumbycellcolor('sheet1:sheet7'!b15:b27,b14)
b14 being the color
ranged between b15:b27
but i have mar...
Hi,
There is no function in Excel called (sumbycellcolor), you have to use third-party solutions to get this functionality! Follow the below links:
http://www.excelexchange.com/SumByColor.html
https://www.extendoffice.com/documents/excel/1418-excel-count-sum-by-font-color.html
But, I don't think these solutions work across multiple sheets!
so theres no way to make it work across multiple sheets like the normal SUM function?
Maybe, but that requires some changes in the source code of these solutions.
I tried to change it but it didn't work!