excel 2000 formula

[dtaylor]

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?

 

[Rick B]

This is an ACCESS newsgroup, not an EXCEL newsgroup.

Sorry, wrong group.

 

[yong bin]

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?

 

[kabaka]

Wrong newsgroup but the formula you want is

=Sumproduct(array1,array2,...)