#### cflorackis

##### Board Regular

- Joined
- Aug 18, 2002

- Messages
- 137

I have the following Table and I need to calculate the average values of the weight of specific subgroups of individuals (e.g. average weight of males that are over 20 years old). Is there a way to do that without filtering the data all the time and copying and pasting information to different spredsheets. Also, is there a way to create new columns that only contain the innformation required each time (e.g. list of the weight of those individuals that are males over the age of 20)

Than you very much in advance

aaaaaaaaaaa.xls | |||||||
---|---|---|---|---|---|---|---|

A | B | C | D | E | |||

1 | person | gender | age | weight | |||

2 | 1 | male | 25 | 80 | |||

3 | 2 | female | 26 | 58 | average weight of males >20 years old | ||

4 | 3 | female | 32 | 84 | average weight of males >30 years old | ||

5 | 4 | female | 14 | 78 | average weight of males >40 years old | ||

6 | 5 | female | 16 | 90 | average weight of males >50 years old | ||

7 | 6 | male | 85 | 125 | |||

8 | 7 | male | 80 | 150 | |||

9 | 8 | female | 92 | 88 | average weight of females >20 years old | ||

10 | 9 | male | 17 | 59 | average weight of females >30 years old | ||

11 | 10 | male | 48 | 88 | average weight of females >40 years old | ||

12 | 11 | female | 23 | 47 | average weight of females >50 years old | ||

13 | 12 | male | 28 | 49 | |||

14 | 13 | female | 45 | 150 | |||

15 | 14 | female | 78 | 98 | |||

16 | 15 | male | 82 | 95 | |||

17 | 16 | female | 19 | 69 | |||

18 | 17 | male | 52 | 82 | |||

Sheet1 |