software

Below is an example of my spreadsheet. I'd like to find the average
number of users for each quot;Day of the weekquot; hour combination but I'm
not even sure where to start.Date HourDoW # Users
10/27/200310Mon11
10/27/200311Mon11
10/27/200313Mon10
10/27/200314Mon11
10/27/200315Mon9
10/27/200316Mon9
10/28/20038Tue5
10/28/20039Tue6
10/28/200310Tue4
10/28/200311Tue8
10/28/200313Tue7
10/28/200314Tue7
10/28/200315Tue7
10/28/200316Tue10
10/29/20038Wed7
10/29/20039Wed10
10/29/200310Wed11
10/29/200311Wed10
10/29/200313Wed10
10/29/200314Wed9
10/29/200315Wed11
10/29/200316Wed10I have put your example data in cells A1 to D23, using the top row for
headings. In E2 to E4 I have entered quot;Monquot;, quot;Tuequot; and quot;Wedquot; (without
the quotes), and in F2 I have entered this formula:

=SUMIF(C$2:C$23,E2,D$2$23)/COUNTIF(C$2:C$23,E2)

and copied down to F4. You don't have an entry for 12 noon - I've
assumed that is lunchbreak, so each entry in the table is equivalent to
1 hour.

Hope this helps.

Pete