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.