Results 1 to 5 of 5

SUMIFS vs SUMIF - 2 Criterias needed

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2010
    Posts
    16

    Question SUMIFS vs SUMIF - 2 Criterias needed

    Dear Forum,

    I have 2 sheets of data in the same workbook.

    a) My first sheet, Table1 (Which I will be using to present data) is as follows:
    LocationID Last 2 Month's Payment Last 12 Month's Payment
    LONCLEVER
    OSAACE123
    SYDSPEEDY
    NYCXYZ000
    LONCLEVER
    NYCXYZ000

    b) My second sheet, Table2 (With the data that needs to be calculated) is as follows:
    LocationID Receipt Date Receipt Amount
    LONCLEVER 8/1/2013 6,474
    OSAACE123 8/9/2013 100,569
    SYDSPEEDY 4/5/2013 27,300
    NYCXYZ000 4/5/2013 39,000
    LONCLEVER 9/1/2013 70,000
    NYCXYZ000 4/5/2013 500,000

    Essentially - I am trying to find out:
    1) Last 2 Month's Payment
    2) Last 12 Month's Payment
    Based on days from today's date and LocationID.

    My pathetic attempt was:
    =SUMIF(Table2[#ALL], TODAY()-Table2[@[Receipt Date]]>=60, Table2[@[Receipt Amount]]) and
    =SUMIF(Table2[#ALL], TODAY()-Table2[@[Receipt Date]]>=60, Table2[@[Receipt Amount]])
    I keep on getting zero...

    Could someone please kindly point me to the right way here? Very much appreciated!
    Many thanks in advance.

    Kind Regards,
    Last edited by jhsiao; 11-18-2013 at 01:46 AM. Reason: Title was not concise

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Sumifs
    By Stepside in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2013, 04:23 PM
  2. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  3. Sumifs
    By floricita in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2012, 01:13 PM
  4. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  5. Excel 2007 : SUM(IF or SUMIFS
    By arangoa79 in forum Excel General
    Replies: 2
    Last Post: 06-24-2010, 01:29 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