Results 1 to 3 of 3

Thread: Add multiple cells(cells are in incremental of 9)

  1. #1

    Question Add multiple cells(cells are in incremental of 9)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I want to add multiple cells.
    this cells are in incremental of N number.

    eg
    a3+a8+a13+a18 and so on.....

    actually this adding goes upto 52cells.
    thus manual adding is not possible.

    can I do this by formula...?

    Thanks in advance.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try something like:

    =SUMPRODUCT(--(MOD(ROW($A$3:$A$100)-ROW(A3),5)=0),$A$3:$A$100)

    adjust the A3:A100 ranges to the outerbounds of your actual range.


  3. #3
    Many Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •