I am struggling to find a formula that can be copied, I would like to avoid doing it manually as it would be very time consuming. My goal is to have a formula that takes and average of 10 numbers from another tab that are spaced 20 columns apart. Suggestions? Macros or the offset function?