Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Sumif Based On Cell Color

  1. #1
    Join Date
    10th February 2005
    Posts
    10

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,541

    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
    _______________________________________________
    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

    _______________________________________________

  3. #3
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,541

    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
    _______________________________________________
    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

    _______________________________________________

  4. #4
    Join Date
    10th February 2005
    Posts
    10

    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.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. SumIf By Cell Color
    By hgus393 in forum OPEN SOURCE: Hey! That is Cool!
    Replies: 2
    Last Post: May 16th, 2008, 21:59
  2. Change Font Color Based On Adjacent Cell Color
    By moneyshot1 in forum EXCEL HELP
    Replies: 3
    Last Post: April 18th, 2008, 10:19
  3. Replies: 3
    Last Post: April 12th, 2008, 10:04
  4. Sumif Criteria Based On Color Of Cell Or Text
    By MJohn1978 in forum EXCEL HELP
    Replies: 2
    Last Post: May 2nd, 2007, 21:59
  5. Change Text Color Based on Cell Color.
    By Jeff P in forum EXCEL HELP
    Replies: 5
    Last Post: October 18th, 2006, 15:41

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno