Announcement

Collapse
No announcement yet.

Sumif Based On Cell Color

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sumif Based On Cell Color

    Hi,
    This may be a simple question. I have just installed Excel 2007. Is there a way to sum a range of cells based on cell color in Excel 2007 without creating a macro or UDF?
    Thanks. Iwas told there was, but I can't find it and for some my reason my help index is corrupt. Thanks.

  • #2
    Re: Sumif Based On Cell Color

    Honestly, without a Macro, I really dont think this is possible, at least in Excel 2003 and below. Not sure about Excel 2007, they may have made something fancy. In any case, the following links will guide you through the relevant UDF's / Macros to do this fairly common request.


    HTH
    Ger

    Check out our new reputation system. Click on the "star" under the post!
    _______________________________________________

    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

    Comment


    • #3
      Re: Sumif Based On Cell Color

      h t t p://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

      http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm
      http://www.ozgrid.com/VBA/Sum.htm

      Check out our new reputation system. Click on the "star" under the post!
      _______________________________________________

      There are 10 types of people in the world. Those that understand Binary and those that dont.

      Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

      The BEST Lookup function of all time

      Dynamic Named Ranges are your bestest friend

      _______________________________________________

      Comment


      • #4
        Re: Sumif Based On Cell Color

        Thanks. I understand how this works, used in Excel 2003. I was hoping to see if Excel 2007 has a built in function, in the meanwhile I will use the UDF you provided.
        Thanks again.

        Comment

        Working...
        X