View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Randy K
 
Posts: n/a
Default Need to select rows to average based on a value in a different column

Below is an example of my spreadsheet. I'd like to find the average
number of users for each "Day of the week" hour combination but I'm
not even sure where to start.


Date Hour DoW # Users
10/27/2003 10 Mon 11
10/27/2003 11 Mon 11
10/27/2003 13 Mon 10
10/27/2003 14 Mon 11
10/27/2003 15 Mon 9
10/27/2003 16 Mon 9
10/28/2003 8 Tue 5
10/28/2003 9 Tue 6
10/28/2003 10 Tue 4
10/28/2003 11 Tue 8
10/28/2003 13 Tue 7
10/28/2003 14 Tue 7
10/28/2003 15 Tue 7
10/28/2003 16 Tue 10
10/29/2003 8 Wed 7
10/29/2003 9 Wed 10
10/29/2003 10 Wed 11
10/29/2003 11 Wed 10
10/29/2003 13 Wed 10
10/29/2003 14 Wed 9
10/29/2003 15 Wed 11
10/29/2003 16 Wed 10