Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Texas, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Calc? (Excel 2000 SR-1)

    I'm trying to figure out the easiest way to calculate each person's total dollar allocation based on the time they spend on the projects (based on the sample below):

    Total Spend Jim Sue Bob
    Proj. 1 10,000 0% 100% 0%
    Proj. 2 20,000 10% 50% 40%
    Proj. 3 40,000 100% 0% 0%
    Proj. 4 20,000 0% 50% 50%
    Total 90,000 42,000 30,000 18,000

    There are 30 projects and 12 people. I need to calculate the amount of dollars for each person based on spend amount and the amount of time they spend on the project.

    I hope someone can point me in the right direction.

    Thanks,
    Elaine

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Calc? (Excel 2000 SR-1)

    If I understand correctly:
    Assuming your table is in A1:E5 and the totals in row 6, this in cell C6:
    <pre>=SUMPRODUCT($B$2:$B$5,C2:C5)</pre>

    and copied to D6 and E6
    will give you the "totals"
    Change the ranges as appropriate

    Steve

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Texas, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Calc? (Excel 2000 SR-1)

    Steve - That's exactly what I needed. Thank you so much.

    Elaine

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •