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

  • HOW TO SUM EVERY OTHER COLUMN

    From monir alizadeh@21:1/5 to All on Tue Jul 28 16:47:55 2020
    HELLO,
    I HAVE A LARGE SHEET COLUMNS RANGING FROM D TO WV. I WANT TO SUM EVERY OTHER COLUMNS. PLS HELP ME
    THANKS

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From MyVeryOwnSelf@21:1/5 to All on Wed Jul 29 17:51:48 2020
    I HAVE A LARGE SHEET COLUMNS RANGING FROM D TO WV.
    I WANT TO SUM EVERY OTHER COLUMNS. PLS HELP ME
    THANKS

    Maybe something like this would help.

    Find an unused out-of-the way row. I used row 7.

    In D7, put
    =--ISODD(COLUMN())
    And copy rightward to WV7

    Then the desired result should be
    =SUMPRODUCT(D1:WV1, D7:WV7)

    If you want to start the sum in column E rather than D, use ISEVEN instead of ISODD.

    The extra row can be hidden to avoid clutter.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From MyVeryOwnSelf@21:1/5 to All on Wed Jul 29 18:13:08 2020
    Then the desired result should be
    =SUMPRODUCT(D1:WV1, D7:WV7)

    Correction: better would be
    =SUMPRODUCT(D1:WV1,D$7:WV$7) 

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