+ Reply to Thread
Results 1 to 3 of 3

Assistance with conditional sum formulas

Hybrid View

  1. #1
    Registered User
    Join Date
    09-15-2015
    Location
    New York
    MS-Off Ver
    2007 & 2013
    Posts
    2

    Assistance with conditional sum formulas

    Good afternoon. I have been trying to create a formula that would conduct the following on one sheet where data is residing on another -

    1. Where (Extract!T2:210000, "=Declined"
    2. Sum $'s (Extract!H2:H10000,">0" and Sum $'s (Extract!K2:k10000,">0"

    I know my end results should end up being:
    H (Declined Credits) value = $19,344.77
    K (Declined Refunds)value = $128,035.40
    Total Declines (H + K) = $147,380.17
    Attached Files Attached Files

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Assistance with conditional sum formulas

    For the Credits use:

    =SUMIF(Sheet1!T:T,"Declined",Sheet1!H:H)
    For the Refunds use:

    =SUMIF(Sheet1!T:T,"Declined",Sheet1!K:K)
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    09-15-2015
    Location
    New York
    MS-Off Ver
    2007 & 2013
    Posts
    2

    Re: Assistance with conditional sum formulas

    Thank you ConneXionLost! I was not able to properly construct the SumIf functions and you were able to show me the correct way. I also took your formulas one additional step and combined into a single one for my application:

    =SUM(SUMIF(Extract!T:T,"Declined",Extract!H:H)+(SUMIF(Extract!T:T,"Declined",Extract!K:K)))

+ 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. assistance with conditional formatting
    By PeterG in forum Excel General
    Replies: 3
    Last Post: 10-29-2015, 05:39 PM
  2. Conditional Formatting assistance please
    By MnMCarta in forum Excel General
    Replies: 2
    Last Post: 12-12-2014, 11:21 AM
  3. I'd love some assistance conbining these two formulas in to one!
    By gentelmanjack in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2012, 01:53 PM
  4. Conditional formula assistance
    By lrm75uk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2009, 04:32 AM
  5. Conditional Formatting Assistance
    By Bret in forum Excel General
    Replies: 7
    Last Post: 10-08-2008, 01:39 PM
  6. Conditional Lookup Formulas- Assistance
    By sparkstertom in forum Excel General
    Replies: 7
    Last Post: 10-19-2007, 10:01 AM
  7. [SOLVED] Conditional format assistance
    By Bobby in forum Excel General
    Replies: 7
    Last Post: 04-08-2005, 10:06 AM

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