Sumproduct across mutliple columns

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.

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"JANA" wrote:

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

--
Jacob

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

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