Hello,
Suppose I have a table which record the income for each people in each
area
area income
1 100
2 70
2 60
I would like to (1) count the number of people in each area and (2)
average income
area number of people average income
1 1 85
2 2 60
Thank you.
Gary''s Student - 02 Sep 2006 12:12 GMT
If you want a single table to present both the count and the average, then
use a Pivot Table. If you are not familiar with Pivot Tables, see:
http://www.contextures.com/xlPivot01.html

Signature
Gary's Student
> Hello,
>
[quoted text clipped - 14 lines]
>
> Thank you.