"Ron Coderre" wrote:

With these 2 cell ranges

A1:F7 contains numbers
H1:H6 contains numbers

This ARRAY FORMULA (committed with CTRL+SHIFT+ENTER, instead of just ENTER)
transposes H1:H6 from vertical to horizontal and multiplies A1:F7
by those values:
=SUMPRODUCT(A1:F7*TRANSPOSE(H1:H6))

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


thanks, but not sure this is what I need. Sorry - should have posted the
below in the first instance :

product cs1 cs2 cs3 cs4 cs5 cs6 total
a 4 3 4 3 12 5 139
b 5 2 5 2 3 6
c 3 3 6 4 5 6
d 5 4 4 23 7 5
e 2 4 7 44 6 4
f 3.4 5 6 56 6 5
g 3 6 56 44 6 5



cost/unit cs1 cs2 cs2 cs3 cs4 cs5
2 3 6 3 7 1

effectively i wish to fill the formula giving the figure of 139
:=SUMPRODUCT(D10:I10,D21:I21)

down but without changing the second array argument so that cost/unit is
applied to each row in the top table.

Many thanks