+ Reply to Thread
Results 1 to 5 of 5

sum if cell is certain color

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    102

    sum if cell is certain color

    Hello,

    I have a simple issue. I am looking for a sum formula that will sum a cell if it is a certain color. Does anyone know of a formula for that? looking for a formula not using the Ktools feature - just input formula and drag down. Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,047

    Re: sum if cell is certain color

    Colour isn't data, so, no simple formula. You can use a VBA User Defined Function, but that's the only way I know of doing it.

    See: http://www.cpearson.com/excel/colors.aspx
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Germany
    MS-Off Ver
    2016/365
    Posts
    208

    Re: sum if cell is certain color

    From a database perspective, just assign 0/1 or whatever to a separate column.

    The data looks cleaner and data management, analyses etc. are so much simpler.

    E.g. if a different user is using a different color palette, the cell colors will look different for him/her, so number crunching based on formatting is usually a road to disaster.

  4. #4
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    102

    Re: sum if cell is certain color

    Thanks, going to ignore the sum if color for now and mark this solved.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,047

    Re: sum if cell is certain color

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. User defined function to copy the cell color to another cell (actual painting the color)
    By sumitgangwani in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2017, 04:14 PM
  2. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  3. Swapping cell content to INCLUDE CELL FORMATTING (Text color, background color, etc)
    By jcpeterson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2014, 10:09 AM
  4. Change a Range's cell background color to that of another cell's cond. format color
    By kamelkid2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 12:57 PM
  5. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  6. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  7. Sorting by Cell Color, Font Color or Cell Icon in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-19-2007, 12:23 PM

Tags for this Thread

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