• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumbycolor

Sanussha

New Member
I dont have sum color function in window 11. Could anyone help to suggest or how to add function of the sum color formula in my excel?
 
Here are a few options to add or enable the SUMCOLOR function in Excel on Windows 11:
>>> moderator note >>> Do not try to add hidden links to somewhere <<<

- Make sure you have the latest version of Excel. SUMCOLOR was introduced in Excel 2013, so you need Excel 2013 or newer. Update to the newest version if needed.

- The SUMCOLOR function may be disabled by default in some installations. Go to File > Options > Add-ins. In the Manage box, click Go and enable the Analysis ToolPak add-in if it is disabled.

- You may need to manually add the Analysis ToolPak add-in. Go to File > Options > Add-ins > Manage Excel Add-ins > Go. Check if Analysis ToolPak is listed, if not click Browse and add it from the install folder.

- Enable the SUMCOLOR function manually. In the Name Manager (Formulas tab) click New and define the name SumColor with the following formula: =SUMPRODUCT(1*ISNUMBER(SEARCH(","&COLOR_INDEX&",",","&SUBSTITUTE(CELL("color",A1),".","")&",")))

- Use VBA to create the SUMCOLOR function. Add a new module and define a Function SumColor() with the above formula. Then you can use SumColor in worksheets.

- As a workaround, use COUNTIF with cell color criteria. For example: =COUNTIF(A:A, "cell-color-criterion")
 
Last edited by a moderator:
Back
Top