You don't need any SUMPRODUCTs.

See MMULT in Excel Help
--
Gary''s Student - gsnu200773


"PBcorn" wrote:

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?