Hi,
I am having trouble using autofill to reference every nth cell.
For example, for N=2, I want
For N=5, I want
The values are then summed and multiplied by a constant and then N.
For N=2, SUM(column)*0.035/3*2
For N=5, SUM(column)*0.035/3*5
Attached is the .xlsx of a small representative data of what I am trying to achieve.
N.B.: I have asked a similar question and was answered by user Glenn Kennedy prior in a thread called "Autofill referencing non-adjacent cells" (unable to post URL link). He used an array formula which may be applicable to this case. I have been unsuccessful in modifying the formula for this new scenario although it may speed up in reaching a solution to my problem. Once again, appreciate any help given!
Bookmarks