I calculate the labor costs for a list of job based on a list of 32
trades each of which has its own rate, using mmult(row of hours for
each trade,row of rates for each trade). This is done for a list of 10
to 100 different jobs and is working fine.

The problem that has me stuck is that I now have a requirement to price
a certain % of the hours for each trade at a different rate. Basically
a certain percentage of the hours is to be assigned to temps, and they
have different rates. I know I can readily replicate the 32 columns of
trades, populate the new set of columns with the % of the original
columns that get priced at the temp rate and use my mmult formula to
calculate the temp labor costs from the 32 new columns. Of course I
would also need a new set of 32 columns for the in-house % to multiply
by the in-house labor rates. That is an extra 64 columns that I would
like to avoid with a formula like

=mmult(row of 32 trades, (column of 32 rates * parallel column of 32
%'s) )

I really need to get this to work because I also have a requirement to
calculate the straight time and overtime, which is based on multiplying
each row by a % unique to that row. I could do that with another 64
columns as well, but, I want to avoid that as well. I am pretty sure
if I can solve the issue above, I can rotate the solution to handle

=mmult( (row of 32 trades * parallel row of 32 %'s),column of 32 rates)

and then the ultimate goal of

=mmult((row of 32 trades * parallel row of 32 %'s) , (column of 32
rates * parallel column of 32 %'s))

Although I have never posted to this group before, I have been fairly
active in the programming group and I see many familiar names here. I
hope someone can get me going in the right direction.

Thanks

Ken