In my workbook there is a small example table of what I am trying to use.

The test data runs from B2 through to AE23

Column B and Column C have resource numbers in them.

Column D-AE have hours per day.

The SUMPRODUCT should take the value from column B, divide it by the sum of column B,C to get a percentage, then multiply it by the hours per day from column D through AE to get a daily total.

The second SUMPRODUCT should do the same, but use column C divided by the sum of B,C to get a percentage then multiply it by the hours per day from column D through AE to get a daily total.

Help.....

SUMPRODUCT.xlsx

The test data runs from B2 through to AE23

Column B and Column C have resource numbers in them.

Column D-AE have hours per day.

The SUMPRODUCT should take the value from column B, divide it by the sum of column B,C to get a percentage, then multiply it by the hours per day from column D through AE to get a daily total.

The second SUMPRODUCT should do the same, but use column C divided by the sum of B,C to get a percentage then multiply it by the hours per day from column D through AE to get a daily total.

Help.....

SUMPRODUCT.xlsx

=SUMPRODUCT($B2:$B23,D2:D2

and

=SUMPRODUCT($C2:$C23,D2:D2

This latter in column D with give 4 * 10 / 63.

Without knowing whether that is truly what you want, I cannot go any further. Is that the right answer?

C7/(SUM(B7,C7)*D7 = 40

B7=0, C7=4 and D7=10

So, according to your formula, you have

4/(4+0)*10. This equals 10, not 40.

Would you please clarify what you want.

Try this array formula for MW (D25)

=SUM((IFERROR($B$2:$B$23/(

And the similar for WD (D26)

=SUM((IFERROR($C$2:$C$23/(

The formulas must be entered with Ctrl+Shift+Enter

See sheet

SUMPRODUCT.xlsx

## Premium Content

You need an Expert Office subscription to comment.Start Free Trial