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.
is there any formula to add these columns with in single shot.
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
In AVM2
=SUMPRODUCT(--(MOD(COLUMN(A2:AVL2),14)=0),A2:AVL2)
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
If you are including column A as col 1, the 14th columns thereafter would be columns 15, 29, 43, 57 etc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.