Link to home
Start Free TrialLog in
Avatar of BISWAJEET PADHI
BISWAJEET PADHI

asked on

need summation of cells of the same row having same column difference between the two cells

i have a excel sheet having 1260 columns , and i need to add values of  columns 1, 14 , 28,..... till 1260 in the multiples of 14.
is there any formula to add these columns with in single shot.
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

can't think of a way to do this if not using formula, but you can get a try using macro
You may try this....

In AVM2
=SUMPRODUCT(--(MOD(COLUMN(A2:AVL2),14)=0),A2:AVL2)

Open in new window

and copy down.
Subodh's suggestion will ignore column A as the result of MOD(A2,14) is 1 and then thereby not included in the SUMPRODUCT.

If you are including column A as col 1, the 14th columns thereafter would be columns 15, 29, 43, 57  etc
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial