+ Reply to Thread
Results 1 to 6 of 6

Sum Functions/formula: selection for addition base off of colours

  1. #1
    Registered User
    Join Date
    10-12-2020
    Location
    Antwerp, Belgium
    MS-Off Ver
    16,41
    Posts
    3

    Sum Functions/formula: selection for addition base off of colours

    Hi all,

    I'd like to pose a question regarding a SUM function. (please refer to the Excel file attached)

    Here, the SUM on the right is the total sum of all the values placed in a row to the left of it. In this row, there are surface areas of two either existing or new doors. The new doors are recorded into excel in the green font. The existing doors are recorded in excel with a black font. I need two different SUM columns: 1. total sum of all the existing door areas and 2. sum of all the new door surface areas.

    Ideally I would use one formula for all of the total sums in the columns to the right. The formula would need to be able to distinguish whether or not it will add a value based off of value's text colour. Is this possible? (for example deriving from complex IF functions, and so on.)

    Thanks for your time!

    Best,

    Eline
    Attached Files Attached Files
    Last edited by Eline Verhoeven; 10-12-2020 at 11:03 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Sum Functions/formula: selection for addition base off of colours

    Hi, please take a moment to read the yellow banner at the top of the page, and then attach a sample sheet, complete with expected answer... not a blurry picture of one!!
    Glenn



  3. #3
    Registered User
    Join Date
    10-12-2020
    Location
    Antwerp, Belgium
    MS-Off Ver
    16,41
    Posts
    3

    Re: Sum Functions/formula: selection for addition base off of colours

    Hi Glenn,

    Thanks for your message. I've uploaded a simplified example file. Hopefully this provides some clarity.

    Thanks!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Sum Functions/formula: selection for addition base off of colours

    A bit of a guess, as you didn't include your expected answers!!

    =SUMIF($D$5:$AH$5,"*New*",$D7:$AH7)

    See sheet for context. You'll need ; instead of ,
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-12-2020
    Location
    Antwerp, Belgium
    MS-Off Ver
    16,41
    Posts
    3

    Re: Sum Functions/formula: selection for addition base off of colours

    Thanks Glenn - this formula works perfectly.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Sum Functions/formula: selection for addition base off of colours

    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. Convert Excel to txt base on Selection
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-29-2018, 08:02 AM
  2. [SOLVED] Auto update (addition) based on base data
    By Amolvijay in forum Excel General
    Replies: 2
    Last Post: 02-10-2014, 11:12 AM
  3. Changing Cell Colours on Selection & Text Input
    By JayWeb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2009, 09:59 AM
  4. Addition in base 6
    By Barking_Mad in forum Excel General
    Replies: 2
    Last Post: 06-14-2009, 04:49 AM
  5. Addition/Subtraction with Menu Selection
    By slvr98svt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2009, 10:09 AM
  6. [SOLVED] vaiable colours for selection in chart
    By NoelH in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-27-2005, 12:05 AM
  7. [SOLVED] Addition base on condition
    By 68magnolia71 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-15-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1