I would like to use a formula (LOOKUP?) to enable me to do the following:

In column A: I have the time in 15 minute time intervals
In column B: I have variable groups called €˜route IDs (€˜a, €˜b, ;c; etc)
In column C: I have call volumes per 15 minute period for each route ID
In columns L & N: I have 2 sets of data which when summed will give me
the call handling time for that 15 min period for that route ID.

The info is organised as follows
A B C €¦€¦€¦. L N

Time Route ID Call volume CHT1 CHT2

08:00 a 10 778 521
0800 a 15 498 615
0800 b 14 769 1021
0800 a 17 28 1400
0800 b 25 269 743
0800 a 18 890 1005
0815 b 21 777 650
0815 a 45 900 740
0815 a 46 210 367
0815 b 74 456 789

etc

What formula/function would I need and how would this be applied to the
above to give me:

1. The average call volume for each 15 minute period for a particular route
ID (say called €˜a, €˜b, €˜c etc)

2. The average call handling time (CHT) for each 15 minute period for a
particular route ID

Many thanks