Results 1 to 16 of 16

Sum values contained in record and multiply those values by the column's associated lookup

Threaded View

cworkman123 Sum values contained in... 08-25-2015, 02:15 PM
FerJo Re: Sum values contained in... 08-26-2015, 12:23 AM
cworkman123 Re: Sum values contained in... 08-26-2015, 09:23 AM
FerJo Re: Sum values contained in... 08-27-2015, 04:26 AM
cworkman123 Re: Sum values contained in... 08-31-2015, 03:41 PM
FerJo Re: Sum values contained in... 08-31-2015, 08:27 PM
cworkman123 Re: Sum values contained in... 09-02-2015, 10:32 AM
cworkman123 Re: Sum values contained in... 09-02-2015, 10:33 AM
FerJo Re: Sum values contained in... 09-03-2015, 06:26 AM
cworkman123 Re: Sum values contained in... 09-03-2015, 10:15 AM
cworkman123 Re: Sum values contained in... 09-03-2015, 10:20 AM
FerJo Re: Sum values contained in... 09-04-2015, 07:16 AM
cworkman123 Re: Sum values contained in... 09-04-2015, 11:24 AM
FerJo Re: Sum values contained in... 09-07-2015, 08:27 PM
cworkman123 Re: Sum values contained in... 09-09-2015, 03:05 PM
FerJo Re: Sum values contained in... 09-09-2015, 08:42 PM
  1. #1
    Registered User
    Join Date
    01-05-2015
    Location
    United States
    MS-Off Ver
    2013
    Posts
    30

    Sum values contained in record and multiply those values by the column's associated lookup

    Hello everyone,

    I'm not sure my title is the greatest for this problem, but I am unsure how to explain it in such a short sentence.

    Basically, I would like to calculate the professional fees of certain roles, during certain phases of a project. In my sample file you will find two worksheets. The first Worksheet is Deliverables (this is the phases of the project) and the second Worksheet is Deliverable Summary (a summary of the fees associated with each phase (deliverable) of the project).

    In the Deliverables worksheet, you will see that every Deliverable has a Tab Level of 1 in the column to the left of it. This is an indicator of phases. Between each tab level of 1, is a phase of the project. To the right of the Deliverable's you will find days worked by certain roles (Role 1, Role 2, Role 3, etc.) and their respective days worked under them. Please note that there are days worked in the Sub Deliverable and not the main Deliverable (the ones with a Tab Level of 1).

    In the Deliverable Summary worksheet, you will see a table that I have summarized to the best of my ability.

    Professional Services column is a list of all Phases in the Deliverables worksheet, to the right is the summation of the deliverable's Professional Days (Professional Days column). In the same worksheet you will find a table called Role's Daily Fee, this table contains the Role's fees.

    I would like the professional fees column to calculate the total fees (Roles * Days) by Phase.

    In the attached sample file, you can see my manual calculation in the Deliverable Summary worksheet - Professional Fees Column.

    VBA or Worksheet Function?
    If a formula isn't possible I would be okay with doing this via VBA Macro, but I'm not sure where to start there either! If this isn't clear, please don't hesitate to ask so that I may clarify.

    Thank you very much,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find specific values and multiply them by a number in their column
    By Thomas92W in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-29-2014, 01:22 PM
  2. I need help to multiply a column with values by 180% & then ROUNDUP to 1 decimal
    By RobinPrice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2014, 06:21 AM
  3. [SOLVED] Copy values from one column to the end of values already contained in the cell of another
    By GavJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2013, 01:19 AM
  4. [SOLVED] How to multiply a range of values without creating a new column
    By BNCOXUK in forum Excel General
    Replies: 4
    Last Post: 08-01-2012, 04:14 AM
  5. Lookup values contained in a text string
    By byroniko in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-16-2010, 07:53 AM
  6. lookup values in table, return sum of values from first column
    By owenkam in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-10-2010, 05:20 AM
  7. Replies: 2
    Last Post: 04-01-2006, 12:47 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