Just use absolute references where necessary.

=SUMPRODUCT(A1:G1,$A$17:$G$17)

Copying this down produces:

=SUMPRODUCT(A2:G2,$A$17:$G$17)
=SUMPRODUCT(A3:G3,$A$17:$G$17)
=SUMPRODUCT(A4:G4,$A$17:$G$17)
.... etc.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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?