Forum Discussion

r cardenas's avatar
r cardenas
Copper Contributor
Nov 21, 2017

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?

Excel Desktop
Formulas & Functions

3 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Nov 21, 2017

    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!

    • r cardenas's avatar
      r cardenas
      Copper Contributor
      Nov 21, 2017
      so theres no way to make it work across multiple sheets like the normal SUM function?
      • Haytham Amairah's avatar
        Haytham Amairah
        Silver Contributor
        Nov 21, 2017

        Maybe, but that requires some changes in the source code of these solutions.

        I tried to change it but it didn't work!

Resources