alderman
New member
- Joined
- Jan 23, 2014
- Messages
- 19
- Reaction score
- 0
- Points
- 0
Two questions:
1. Is there an equation to determine the average of several combined cells?
In the sample table below I would like to get the average of rows 4-7, but as a group 23, 23, 22, 24, 24 for an average of 23.2 rather than the average of the cells $D$4:$F$8 which is 14.5
2. The next thing I would like to do is concatenate in column A the column headers... for example in A2 and A3 I would like to see C, but in A5 and A6 I would like to see D/E and if there were more than 2 coplumns this could be extended such that the result woudl be D/E/F etc.
Thanks for any help on this.
1. Is there an equation to determine the average of several combined cells?
In the sample table below I would like to get the average of rows 4-7, but as a group 23, 23, 22, 24, 24 for an average of 23.2 rather than the average of the cells $D$4:$F$8 which is 14.5
2. The next thing I would like to do is concatenate in column A the column headers... for example in A2 and A3 I would like to see C, but in A5 and A6 I would like to see D/E and if there were more than 2 coplumns this could be extended such that the result woudl be D/E/F etc.
Thanks for any help on this.
A | B | C | D | E | F | G | H | I | J | K | |
1 | Avg | ||||||||||
2 | 21 | ||||||||||
3 | 22 | ||||||||||
4 | 23 | ||||||||||
5 | 16 | 7 | |||||||||
6 | 15 | 7 | |||||||||
7 | 16 | 8 | |||||||||
8 | 24 | ||||||||||
9 | 23 | 6 | |||||||||
10 | 21 | 6 | |||||||||
11 | 20 | 8 | |||||||||
12 | 28 |