+ Reply to Thread
Results 1 to 3 of 3

Sumif Year & Month match

  1. 05-25-2016, 03:59 AM #1
    Seve
    Seve is offline
    Registered User
    Join Date
    12-07-2010
    Location
    Aberdeen
    MS-Off Ver
    Excel 2013
    Posts
    50

    Sumif Year & Month match

    Can anyone help me with this please.

    I have a workbook with two sheets. On the First sheet I am trying to show when costs from the Second sheet relate to by PO and by Period.

    On the second sheet I have invoice values that refer to 1) a PO and 2) a Period Work carried out.

    For the life of me I cannot get the Sumif function to recognise the Year() Month() of the Period Carried out and Match these to the correct Month Year Column on the Summary sheet.
    Hope this makes sense!

    Sample workbook attached!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-25-2016, 04:53 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,076

    Re: Sumif Year & Month match

    in G4
    =SUMPRODUCT(--(A4='Invoice Register'!B$3:B$16)*(EOMONTH('Invoice Register'!E$3:E$16+0,0)=G$3)*('Invoice Register'!J$3:J$16))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 05-25-2016, 05:08 AM #3
    Seve
    Seve is offline
    Registered User
    Join Date
    12-07-2010
    Location
    Aberdeen
    MS-Off Ver
    Excel 2013
    Posts
    50

    Re: Sumif Year & Month match

    Thank you Special-K that works exactly as I wanted it to!
    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. Sumif with in the same month and year
    By jackson_hollon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2015, 06:54 PM
  2. SumIf dates...month & year!
    By RossInk in forum Excel General
    Replies: 4
    Last Post: 04-09-2015, 01:10 PM
  3. SUMIF date year/month?
    By MjRmatt in forum Excel General
    Replies: 7
    Last Post: 10-18-2014, 01:20 PM
  4. [SOLVED] display cell to show only Month/year to do sumif calc if today()= any day of month
    By fireguy7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 06:55 PM
  5. Sumif by month AND year
    By Ticktockman in forum Excel General
    Replies: 2
    Last Post: 05-03-2011, 01:56 AM
  6. SUMIF formula with Month Year
    By top1 in forum Excel General
    Replies: 3
    Last Post: 04-18-2010, 09:58 PM
  7. SUMIF Month & Year
    By VegasL in forum Excel General
    Replies: 2
    Last Post: 12-18-2009, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1