Forum Discussion
Averaging on a list with multiple undetermined entries per week
Hi All,
I have a sheet where, among other things, I have a list similar to this one:
Week ------ Number
12 2
12 3
14 2
15 3
15 3
15 3
15 1
etc
I would like to have a table that could give me the average of Number in each week like:
Week----Average
12 2,5
14 2
15 2,5
etc
How can I achieve this?
Thanks/Brgds
j
2 Replies
There are a couple of different approaches to this. The most basic would be =AVERAGEIF. This is exactly what it's for. Another option, and the most automatic would be a pivot table. I'm attaching a demo with both options. on Sheet 1, after you add the data it Table1, (Columns A and B), and then add a new line in Table2, (Columns D and E), and manually add the week number, the average will display next to it. if you add the data, and then press Ctrl+Alt+F5, and view Sheet2, you will see the pivot table and how it updates automatically.
- Thanks Bob
