Add multiple cells(cells are in incremental of 9)

Ashurk77

New member
Joined
Jul 9, 2013
Messages
11
Reaction score
0
Points
0
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.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
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.
 
Top