I have a list of data that I want to be able to take every 12 entries and average them. I can't do it by hand because I have over 1000 entries, is there a formula that I can use?
2007-03-05 08:42:01 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
Create a new column
Enter the formula
=INT((ROW()-1)/12)
You will have groups of 12
Create a pivotable and get the average of the groups of 12
2007-03-06 05:11:34 · answer #1 · answered by unnga 6 · 0⤊ 0⤋
Assuming they are in the top row, type "=average(" in the 2nd row, first column. Drag the cursor across the first 12 values, then stop and close the parentheses in the equation. Now click on the
cell with the formula and choose copy from the menu, then select
"paste special, select all the empty cells on the second row and choose "paste special", "formulas".
2007-03-05 16:56:38 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Average for values column A1 to A12
=AVERAGE(A1:A12)
Average for values row A1 to Z1
=AVERAGE(A1:Z1)
also for average for spreadsheet area A1 to M22
=AVERAGE(A1:M22)
2007-03-05 17:01:43 · answer #3 · answered by Anonymous · 0⤊ 0⤋