1. Follow instructions in to Consolidate Lists in tip
2. Select Data -> Consolidate (in Data Tools Group).
3. In Function, select Count and click OK.
4. Select cell A15.
5. Select Data -> Consolidate (in Data Tools Group).
6. In Function, select Average and click OK.