C
Chris Boone
Hello everyone,
I have a spreadsheet that looks similar to this:
Wed 1/1/2003 71
Thu 1/2/2003 204
Fri 1/3/2003 145
Sat 1/4/2003 60
Sun 1/5/2003 40
Mon 1/6/2003 203
Tue 1/7/2003 182
Wed 1/8/2003 228
Thu 1/9/2003 175
Fri 1/10/2003 149
Sat 1/11/2003 112
Sun 1/12/2003 125
Mon 1/13.2003 131
Tue 1/14/2003 139
Wed 1/15/2003 218
I want to get a mean (average) of all of the Wednesdays, then all of the
Thursdays, and so forth. The spreadsheet has over a year's worth of
entries, so I long ago reached the limit of just entering individual cells,
i.e. AVG(b1, b8, b15,...etc.). Does anyone know of a simple way that will
allow me to garner an average for the entire range of data?
Thanks, in advance.
- Chris
I have a spreadsheet that looks similar to this:
Wed 1/1/2003 71
Thu 1/2/2003 204
Fri 1/3/2003 145
Sat 1/4/2003 60
Sun 1/5/2003 40
Mon 1/6/2003 203
Tue 1/7/2003 182
Wed 1/8/2003 228
Thu 1/9/2003 175
Fri 1/10/2003 149
Sat 1/11/2003 112
Sun 1/12/2003 125
Mon 1/13.2003 131
Tue 1/14/2003 139
Wed 1/15/2003 218
I want to get a mean (average) of all of the Wednesdays, then all of the
Thursdays, and so forth. The spreadsheet has over a year's worth of
entries, so I long ago reached the limit of just entering individual cells,
i.e. AVG(b1, b8, b15,...etc.). Does anyone know of a simple way that will
allow me to garner an average for the entire range of data?
Thanks, in advance.
- Chris