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)

"PBcorn" wrote in message
...
Probably a simple query - I wish to use 6 sumproduct formulae to multiply
each row of a 7x6 array by one single 1x6 array. Is this possible without
typing out each ofthe 6 sumproduct formulae individually, or expanding the
1x6 array to a 7x6 array?