excel 2000 formula

[Guest]

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.

 

[Joseph Meehan]

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?

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[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?

 

[Guest]

Wrong newsgroup but the formula you want is

=Sumproduct(array1,array2,...)