+ Reply to Thread
Results 1 to 5 of 5

Sum Values of a Column if meeting conditions within that row

  1. 04-06-2020, 11:18 PM #1
    DIAL90
    DIAL90 is offline
    Registered User
    Join Date
    09-04-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    24

    Sum Values of a Column if meeting conditions within that row

    I've attached a simplified spreadsheet that should make clear what I'm asking. If I want to add up the values of everything in Column B but ONLY IF the corresponding Value in Column C is greater than Column D, is there a formula for that that saves me having to write individual 'IF' formulas for each row?

    Thanks
    Attached Files Attached Files
    Last edited by DIAL90; 04-06-2020 at 11:56 PM.
    Reply With QuoteRegister To Reply
  2. 04-06-2020, 11:26 PM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Sum Values of a Column if meeting conditions within that row

    Please try
    =SUMPRODUCT(B2:B5*(C2:C5>=D2:D5))
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 04-06-2020, 11:27 PM #3
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Sum Values of a Column if meeting conditions within that row

    Give this formula a try
    =SUMPRODUCT(--(C2:C5>D2:D5),B2:B5)
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  4. 04-06-2020, 11:39 PM #4
    Ghozi Alkatiri
    Ghozi Alkatiri is offline
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Sum Values of a Column if meeting conditions within that row

    =sumproduct(($c$2:$c$5>$d$2:$d$5)*($b$2:$b$5))
    Reply With QuoteRegister To Reply
  5. 04-06-2020, 11:55 PM #5
    DIAL90
    DIAL90 is offline
    Registered User
    Join Date
    09-04-2018
    Location
    UK
    MS-Off Ver
    2013
    Posts
    24

    Re: Sum Values of a Column if meeting conditions within that row

    All work fine, thanks a lot.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding the values of a column after meeting criterion
    By Mirell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2015, 12:23 AM
  2. [SOLVED] Help counting unique values from column meeting multiple criteria
    By Starchild in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2014, 01:25 PM
  3. Calculating values meeting multiple conditions
    By Scardais excelforum in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-11-2014, 03:27 PM
  4. [SOLVED] How to SUMIF based on column with values meeting a certain frequency of appearance
    By WRX in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2012, 05:15 PM
  5. Count Unique Values in column A when meeting 2 criteria.
    By Rhyl in forum Excel General
    Replies: 5
    Last Post: 04-20-2012, 09:47 AM
  6. Iterate through values meeting specific conditions
    By pico32 in forum Excel General
    Replies: 3
    Last Post: 04-16-2012, 05:14 AM
  7. Meeting two conditions before summing
    By Andeb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1