Share via

SumColor Function

Anonymous
2017-07-20T23:20:23+00:00

For several years in an existing spreadsheet, I have been using a SumColor function:

=SumColor(O208, O2:O205) which sums the values in the range if the color matches the fill color in O208.

Suddenly I am seeing a #Name? error in any cells that are using this function.  Would something have changed recently in Excel that would cause this problem?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-07-21T01:47:13+00:00

    SumColor is not a builtin Excel Function.

    It is a UDF ( User Defined Function)

    See Chip Pearson's site for more on SumColor

    http://www.cpearson.com/excel/colors.aspx

    Probably resides in your Personal Macro Workbook

    Might be it did not get loaded for some reason when Excel started.

    Do a search for that file. . . . . .Personal.xlsb  or  .xlsm

    Generally located in XLSTART folder.

    Gord

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2017-07-21T15:04:44+00:00

    Thanks for the assist Gord!

    0 comments