Forum Discussion

jdbell's avatar
jdbell
Copper Contributor
Nov 05, 2023

sum every other cell in a large range

an easy way to sum a large range of cells including every other cell in the range

3 Replies

  • jdbell 

    Let's say you want to sum cells in B2:B50 in the even-numbered rows 2, 4, ..., 50.

     

    =SUMPRODUCT(B2:B50, --ISEVEN(ROW(B2:B50)))

     

    or

     

    =SUM(IF(ISEVEN(ROW(B2:B50)), B2:B50))

    • ParkerL940's avatar
      ParkerL940
      Copper Contributor
      Can this formula be extended to multiple columns?
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        ParkerL940 

        If you want to sum values in even-numbered rows in A2:B50

         

        =SUM(IF(ISEVEN(ROW(A2:B50)), A2:B50))

         

        If you want to sum values in even-numbered columns in A2:Z2 (i.e. columns B, D, F, ...)

         

        =SUM(IF(ISEVEN(COLUMN(A2:Z2), A2:Z2))

Resources