1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Multiplying columsn and addin the results

    From Daddy Sage@21:1/5 to All on Mon Feb 3 04:09:54 2020
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Vuko Strugar@21:1/5 to Daddy Sage on Tue Feb 4 03:05:43 2020
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Daddy Sage@21:1/5 to All on Thu Feb 20 22:39:03 2020
    tirsdag den 4. februar 2020 kl. 12.05.46 UTC+1 skrev Vuko Strugar:
    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

    Sorry! it took me so long to get back, but it works. Thank you.

    Jan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)