+ Reply to Thread
Results 1 to 7 of 7

Help with last year SUMIFS depending on what fiscal year week it is now

  1. #1
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    223

    Help with last year SUMIFS depending on what fiscal year week it is now

    Add column G on tab 2015 for the department keyed into cell G7 on the Chart tab and the store keyed into F1 on the Chart tab for the weeks up to what is keyed into C23 on the Chart tab.

    (Last years department 5 totals for store 16 up to this week last year.) (If this is week 201646, I want it to add up last year week 201501 through 201546.)

    I hope I made it clear enough and didn't confuse anyone.

    I am using this formula, but it adds up the entire year.
    Please Login or Register  to view this content.
    I have attached a very slim example, but I still had to zip it.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Help with last year SUMIFS depending on what fiscal year week it is now

    Hi,

    If I understand correctly. You can add this to the end of your formula:

    Please Login or Register  to view this content.
    Hope this is helpful.

    Cheers

  3. #3
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    223

    Re: Help with last year SUMIFS depending on what fiscal year week it is now

    Quote Originally Posted by southward View Post
    Hi,

    If I understand correctly. You can add this to the end of your formula:

    Please Login or Register  to view this content.
    Hope this is helpful.

    Cheers
    Please Login or Register  to view this content.
    Brings an error.

  4. #4
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    223

    Re: Help with last year SUMIFS depending on what fiscal year week it is now

    Quote Originally Posted by southward View Post
    Hi,

    If I understand correctly. You can add this to the end of your formula:

    Please Login or Register  to view this content.
    Hope this is helpful.

    Cheers
    Please Login or Register  to view this content.
    Brings up $0.00

  5. #5
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Help with last year SUMIFS depending on what fiscal year week it is now

    I am so sorry. That is what I get for trying to type it in free hand.

    It should be C23, not just 23.

    Please Login or Register  to view this content.
    Cell C23 is your WM WEEK data. Subtracting 100 from it will return last years matching week.

    Sorry about that.

  6. #6
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Arkansas
    MS-Off Ver
    Microsoft Excel 2016
    Posts
    223

    Re: Help with last year SUMIFS depending on what fiscal year week it is now

    Quote Originally Posted by southward View Post
    I am so sorry. That is what I get for trying to type it in free hand.

    It should be C23, not just 23.

    Please Login or Register  to view this content.
    Cell C23 is your WM WEEK data. Subtracting 100 from it will return last years matching week.

    Sorry about that.
    Thank you very much. Works perfectly so far.

  7. #7
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Help with last year SUMIFS depending on what fiscal year week it is now

    Glad I could be of some assistance.

    Cheers

+ 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. [SOLVED] week number formula - fiscal year
    By rubz71 in forum Excel General
    Replies: 14
    Last Post: 07-11-2018, 11:16 PM
  2. [SOLVED] Show Year & Fiscal Week (FW)
    By mycon73 in forum Excel General
    Replies: 2
    Last Post: 08-02-2014, 01:33 PM
  3. [SOLVED] Sumifs adding together all the months of a fiscal year
    By laliparker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-13-2014, 10:38 AM
  4. Replies: 6
    Last Post: 05-08-2013, 01:46 PM
  5. how to convert date to fiscal year if fiscal year start at 16th or 17th of July
    By sushil shakya in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2013, 03:32 AM
  6. autocalculate current week of fiscal year?
    By zb61 in forum Excel General
    Replies: 6
    Last Post: 06-14-2012, 02:29 AM
  7. [SOLVED] How do i calculate fiscal week of the year
    By evlai@hotmail.com in forum Excel General
    Replies: 4
    Last Post: 09-22-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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1