| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiplying then adding Two Rows of Numbers
I have two sets of numbers in Rows A and B.
I want to create a total at the end of each row along the lines of =(A1*B1)+(A2*B2)+(A3*B3)..........+(A122*B122) Is there a short-hand way to do it, eg via range names. If so, any suggestions would be welcome. Tx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiplying then adding Two Rows of Numbers
Give this a try...
=SUMPRODUCT((A1:A122)*(B1:B122)) Rick "BRob" wrote in message ... I have two sets of numbers in Rows A and B. I want to create a total at the end of each row along the lines of =(A1*B1)+(A2*B2)+(A3*B3)..........+(A122*B122) Is there a short-hand way to do it, eg via range names. If so, any suggestions would be welcome. Tx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiplying then adding Two Rows of Numbers
Maybe
=SUMPRODUCT(A1:A122*B1:B122) Mike "BRob" wrote: I have two sets of numbers in Rows A and B. I want to create a total at the end of each row along the lines of =(A1*B1)+(A2*B2)+(A3*B3)..........+(A122*B122) Is there a short-hand way to do it, eg via range names. If so, any suggestions would be welcome. Tx |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiplying then adding Two Rows of Numbers
=SUMPRODUCT(A1:A10,B1:B10)
"BRob" wrote: I have two sets of numbers in Rows A and B. I want to create a total at the end of each row along the lines of =(A1*B1)+(A2*B2)+(A3*B3)..........+(A122*B122) Is there a short-hand way to do it, eg via range names. If so, any suggestions would be welcome. Tx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for multiplying and adding percentage please help. | New Users to Excel | |||
| multiplying cells and adding that answer in the same cell | Excel Discussion (Misc queries) | |||
| Multiplying non consecutive rows, than adding it. | Excel Discussion (Misc queries) | |||
| Multiplying non consecutive rows, then adding it. | Excel Worksheet Functions | |||
| Sumproduct multiplying instead of adding | Excel Worksheet Functions | |||
Hybrid Mode
