| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiplying columsn and addin the results
In a spreadsheet I have numbers in the first row of each column from A to ?
The numbers has to be multiplied like this A1*B1, C1*D1, E1*F1 and so on. Finally the results have to be added. Is possible in a single formula without entering all the single multiplications in a SUM(); something like =Sum(A1*B1:AX1*AY1)? Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Excel addin versions having LaodBehaviour issue at Addin | Excel Programming | |||
| setup project for Excel addin, won't register addin | Excel Programming | |||
| Combining Text in Columsn | Excel Programming | |||
| multiplying everything in line A X 50 = results in Line B | New Users to Excel | |||
| Unshimmed Automation Addin and Shimmed COM Addin in same App Domai | Excel Programming | |||
Threaded Mode
