Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
How do I break a link to a source when opening Excel 2000? | Excel Worksheet Functions | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |