+ Reply to Thread
Results 1 to 3 of 3

SUMIF columns from another sheet - against a 4-4-5 Calendar

  1. #1
    Registered User
    Join Date
    10-15-2019
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    SUMIF columns from another sheet - against a 4-4-5 Calendar

    Hi everyone, first time posting on this board so forgive me if I have not done this 100% correctly.

    I really need help with a sheet I have titled as 'Forecast Summary' - effectively what this sheet does is pull cost items from multiple tabs which is split as follows (see example below...)

    Capture1.PNG

    On the various tabs that this forecast summary sheet pulls from has each week of the year which is being split against a 4-4-5 calendar, i.e Nov-19 4 weeks, Dec-19 4 weeks & Jan 19 5 weeks... and so on. I then need to be able to copy this formula across each month, the problem being that the 5th column (Total) is an extra column within this sheet, that I dont want to add to the other sheets that it pulls from.

    Effectively what Im looking for is a dynamic SUMIF formula which is flexible to a 4-4-5 calendar, and which can be copies across for approx 24 months!

    Any help will be enormously appreciated!

    Thanks all!!

  2. #2
    Registered User
    Join Date
    10-15-2019
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Re: SUMIF columns from another sheet - against a 4-4-5 Calendar

    SOrry I forgot to mention that to the left of 'WBS Activity' in the above example is a unique code, which needs to pull through from the other tabs (the SUMIF function is as far as I could get!)

    Below is an example of one of the tabs the sheet needs to pull cost from...

    Attachment 645349

    Thanks again!!

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,146

    Re: SUMIF columns from another sheet - against a 4-4-5 Calendar

    Hello Willr204 and Welcome to Excel Forum.
    Not suggesting that I can solve this, however I thought I would point out that selecting the attachment to post #2 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    It may help if you include a couple of the tabs along with a manual mock up of a few of the rows of results that you expect based on those tabs.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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 pulling data from different sheet/columns
    By TatyanaG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2018, 03:22 PM
  2. SUMIF and VLOOKUP selected columns on separate sheet
    By owl4life1867 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2017, 03:56 PM
  3. [SOLVED] Sumif or sumproduct formula for a rolling calendar
    By cartica in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-21-2016, 10:47 AM
  4. Macro to copy dated items on one sheet to formatted calendar on second sheet
    By Ruutintooten in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2016, 12:41 AM
  5. Replies: 3
    Last Post: 06-02-2016, 01:04 PM
  6. [SOLVED] SUMIF by Multiple conditions including calendar month
    By daisiedawn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 04:09 PM
  7. [SOLVED] Sumif issue how to include two columns in a different sheet.
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2013, 11:34 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