View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daddy Sage Daddy Sage is offline
external usenet poster
 
Posts: 24
Default 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