# Thread: Conditional Calc? (Excel 2000 SR-1)

1. ## 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. ## 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. ## 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
•