I need to apply a sumproduct formula across multiple columns.  See example
below:
A        B         C        D        E         F
1       $50     100     120     100     140     150
2       $60     140     90      100     160      140
3       $70     100     50      60       70        80
4       $80     10      100     120     140      200

I need a simpler formula that will give me one total for the following:
sumproduct($A$1:$A$4,B1:B4)+sumproduct($A$1:$A$4,c1:c4)+sumproduct($A$1:$A$4,d1:d4)+sumproduct($A$1:$A$4,e1:e4)+sumproduct($A$1:$A$4,f1:f4).
I have 20 columns across and do not want to add 20 individual sumproduct
formulas.

Thanks in advance!
Jana

What I would do add a column which sums your 20 columns. Then calculate your
Sumproduct, as in:
=sumproduct(a1:a4,t1:t4)

Regards,
Fred

Try
=SUMPRODUCT(A1:A4*B1:F4)

--
Jacob

This will do the same thing as long as there is no text in the range.

=SUMPRODUCT(A1:A4*B1:F4)

--
Biff
Microsoft Excel MVP