#### alderman

##### New member

- Joined
- Jan 23, 2014

- Messages
- 19

- Reaction score
- 0

- Points
- 0

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 |