Hello,
I need to average some data 7 columns at a time. so if you look at the screen shot i would need to average row 14 from AI to AO the from AP to AV etc etc. then do the same for the other rows, the problem is that I cannot use Average(AI14:AO14) and drag the formula as it only shifts over 1 column. any advice?
I removed the screen shot as it came up as text. im not sure how to upload from a URL
I need to average some data 7 columns at a time. so if you look at the screen shot i would need to average row 14 from AI to AO the from AP to AV etc etc. then do the same for the other rows, the problem is that I cannot use Average(AI14:AO14) and drag the formula as it only shifts over 1 column. any advice?
I removed the screen shot as it came up as text. im not sure how to upload from a URL
Last edited: