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 marked error...
anyone know how to fix this?
Hi,
There is no function in Excel called (sumbycellcolor), you have to use third-party solutions to get this functionality! Follow the below links:
Sum By Color and Count By Color using VBA in Microsoft Excel
How to count/sum cells based on the font colors in Excel?
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!
