Multiplying columsn and addin the results
If last cell is AY1, i.e., last pair to multiply is AX1*AY1, as you wrote in your example, then try this formula:
=SUMPRODUCT(A1:AX1,B1:AY1,--(MOD(COLUMN(B1:AY1)-COLUMN(A1),2)=1))
For different range, adjust AX and AY accordingly.
On Monday, 3 February 2020 13:09:56 UTC+1, Daddy Sage wrote:
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
|