Closed Thread
Results 1 to 2 of 2

sum multi column with week heading and summarize into months

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    Madison, WI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question sum multi column with week heading and summarize into months

    Hi - I hope someone can help me with this.


    1. I have a worksheet (A) that has several columns for each week. In each column there isnumber of resources needed next to a task of a project. One column is incremental resources, next is reallocated resources and next is offshore resources. The heading of the column is week. Think of a gantt that has task and next to it is resource instead of date. the date is the heading.
    2. I have a worksheet (B) that has a column for each month and year (Jan-14,Feb-14…Dec-14) that I want to summarize the resources of each week the resources needed from sheet (A) under a monthly coilumn.
    3. I want to update the columns from sheet (A) that is dynamic with the resources (Associated with tasks, but don’t want the tasks copied just resource numbers) and could start in any month.
    4. Sheet A each month has multiple columns as they are based on week. The month consists of 3 to 4 weeks and must sum up each weeks resource in the month.

    Worksheet A
    4/24/14 5/1/14 5/7/14 5/14/14 6/1/14 6/7/14 … 12/31/14
    Pro1 Incremental 5 9 8 6 9 6 … 8
    Proj1 ReAllocated 2 0 7 5 5 5 … 6
    Proj2 Incremental 7 9 15 11 14 11 … 14
    Proj2 ReAllocated 2 4 6 4 9 4 … 2

    Worksheet B
    Jan-14 Feb-15 Mar-14 Apr-14 May-14 Jun-14 … Dec-14
    Incremental 0 0 0 13 58 40 22
    ReAllocated 0 0 0 4 27 23 8
    Total 0 0 0 17 85 63 30

    Your help would be greatly appreciated. Thank You.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,491

    Re: sum multi column with week heading and summarize into months

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to summarize transactio values by week
    By adelkam in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-12-2014, 07:48 PM
  2. Best way to Summarize Table Quarter, week & State
    By shiva_reshs in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-26-2013, 06:36 AM
  3. Is there an excel function summarize data according to Day of week?
    By Eaglekirk in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-23-2013, 07:02 PM
  4. Summarize Accounts vs Months Budget with Pivot Table
    By joedrummer in forum Excel General
    Replies: 0
    Last Post: 02-16-2012, 03:26 PM
  5. [SOLVED] In a table produce an value by column heading and row heading
    By naflan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 01:25 PM

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