Trouble calculating regular averages in Excel
October 18, 2009 8:40 PM Subscribe
In Excel, how do I calculate the average of every 300 data points in a large data set?
posted by Midnight Rambler to computers & internet (10 answers total) 1 user marked this as a favorite
I have ~12000 data points in Excel. I want to take the average of every 300 points (ie. Average(A1:A300), Average(A3001:A6001)). If I write the first formula out, or even write the first few iterations, then drag and fill to complete the rest, it doesn't follow my pattern. It just takes the average starting from the next row in the data (not the row 300 down). As far as my Excel knowledge takes me I'll have to write the formula out 40 times each time I want to analyze a different data set.
Is there a quicker way for Excel to do this?