excel 2000
 

Row 1 has prices of product. Row 2, 3, etc....have quantity required for each
poroduct. At end of each row, need to have amount show.

Example: (B2*A1)+(B3*A2)+(B4*A3)+............=amount

What formula do I use so that I do not have a long formula?

do you really mean for B2 to be paired with A1
if so
use
=sumproduct(A1:A10,B2:B11)
(if you have 10 items)
in the columns are to stay together
=Sumproduct(A1:A10,B1:B10)
change the ranges as needed.

"dtaylor" wrote:

Row 1 has prices of product. Row 2, 3, etc....have quantity required for each
poroduct. At end of each row, need to have amount show.

Example: (B2*A1)+(B3*A2)+(B4*A3)+............=amount

What formula do I use so that I do not have a long formula?

oops
=sumproduct($A$1:$A$10,B2:B11)

and

=Sumproduct($A$1:$A$10,B1:B10)

"bj" wrote:

do you really mean for B2 to be paired with A1
if so
use
=sumproduct(A1:A10,B2:B11)
(if you have 10 items)
in the columns are to stay together
=Sumproduct(A1:A10,B1:B10)
change the ranges as needed.

"dtaylor" wrote:

Row 1 has prices of product. Row 2, 3, etc....have quantity required for each
poroduct. At end of each row, need to have amount show.

Example: (B2*A1)+(B3*A2)+(B4*A3)+............=amount

What formula do I use so that I do not have a long formula?