+ Reply to Thread
Results 1 to 3 of 3

COUNT (or SUM?) colored cells

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    Guildford
    MS-Off Ver
    Excel 2003
    Posts
    1

    COUNT (or SUM?) colored cells

    Hi I am really stuck with this so hoping someone can help me!

    I need to add up the number of cells in a row that have been filled a certain color (manually). The color of those cells are RGB is 255,192,0 and I'm using Excel version 2007. Please don't send me to http://www.cpearson.com/excel/colors.aspx because I've read it and tried various things and it hasn't worked!

    I'm a real newbie so non-technical language would be appreciated!! Thank you

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: COUNT (or SUM?) colored cells

    well thats it cpearson or otherways like it are the way to count colours!
    why are they coloured whats the logic?
    another way in excel 2007 tho
    assuming the cells to be counted are the same colour say yellow and have something in them (not formulas)
    say range a2:a10
    in b1 put =SUBTOTAL(103,A2:A10)
    filter a2:a10 by the colour
    b1 will be the count of cells coloured yellow that are not blank
    Last edited by martindwilson; 03-26-2012 at 08:39 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: COUNT (or SUM?) colored cells

    Hi,
    May be with macro from excel4 only working in name define
    Define a name "GetColor" with reference to =Get.Cell(63;<cell reference>) : code 63 read the cell color
    Create a table in order to read color of each line and column : =GetColor
    See attached example file
    Hope this helps
    Best regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1