Sumproduct across mutliple columns

[JANA]

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 don't want to add 20 individual sumproduct
formulas.

Thanks in advance!
Jana

 

[Fred Smith]

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

 

[Jacob Skaria]

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

 

[T. Valko]

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)

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

=SUMPRODUCT(A1:A4*B1:F4)