Problems of this type are solved through matrix multiplication. Excel
has in-built functions to do this ie "MMULT".

The format is thus, highlight your output range then enter the Excel
function; "=MMULT(Range1,Range2)" followed by CTRL+SHIFT+ENTER. All
being well the output will apear in your output range (I tried it on
your sheet with no problems provided you enter zero's in the empty input
cells). Subsequent changes to your input data automatically updates the
output so once you have set up your sheet there is no need to redo it
each time.

There are a few important rules with matrix algebra, one being that the
two ranges to be multiplied must match each other ie the number of
columns in the first range to be multiplied must match the rows in the
second range if not Excel will return errors.

If you need more help, email me your attachment and I will insert the
formula for you.

StephenS

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!