+ Reply to Thread
Results 1 to 8 of 8

SUMIF Help

  1. #1
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    SUMIF Help

    For some reason I cannot attach my sheet, but here is what im having issues with

    =SUMIF(Ledger!B:B,(AND("Cash",Ledger!A:A<=E4)),Ledger!D:D)

    I want this function to SUM IF On the sheet "Ledger" column B is "Cash" and Column A(The date) is less than E4 which is the date on the primary sheet. If both of these conditions are met, sum the values in column D on the ledger.

    Primary sheet picture: https://gyazo.com/4bd99301a453cbcd87352b98b779e11f
    Ledger picture: https://gyazo.com/459561ac3851ab690281543c82cb1612


    To clarify, I want to use SUMIF to add the values from the ledger if they are "Cash" and Before the date of 1/29/16 (E4).

    Thanks for your help.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: SUMIF Help

    Have you tried SUMIFS? Since you want to sum if more than 1 condition is met, I think you have to use sumifs.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    Re: SUMIF Help

    Ill try, thanks GMR

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: SUMIF Help

    No problem.

  5. #5
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    Re: SUMIF Help

    I tried this: =SUMIFS(Ledger!D:D,Ledger!B:B,"Cash",Ledger!A:A,Ledger!A:A<=E4)
    But this doesn't seem to work. I wish I could attach my file.

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIF Help

    Quote Originally Posted by loganc123 View Post
    I tried this: =SUMIFS(Ledger!D:D,Ledger!B:B,"Cash",Ledger!A:A,Ledger!A:A<=E4)
    Maybe this...

    =SUMIFS(Ledger!D:D,Ledger!B:B,"Cash",Ledger!A:A,"<="&E4)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  7. #7
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    Re: SUMIF Help

    And your a genius. Thanks a lot.

  8. #8
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIF Help

    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. SumIf formula or Sumif with pivottable combined question
    By mcgleeuw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2015, 01:05 PM
  2. Replies: 4
    Last Post: 12-04-2014, 02:06 PM
  3. Subtracting from the SUMIF with the difference from the SUMIF range
    By iamblue91 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2014, 09:01 PM
  4. [SOLVED] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  5. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  6. SUMIF Question: SUMIF not blank
    By nickyg in forum Excel General
    Replies: 5
    Last Post: 11-18-2009, 10:07 PM
  7. Nested SUMIF statement or multiple SUMIF's
    By Dan27 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2009, 06:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1