- Joined
- Nov 6, 2003
- Location
- Denver, CO
I feel really stupid asking two of these horrific types of questions in a day, but I have spent a great deal of time through google, the help feature, and books. I think it is time to ask.
I am trying to average two columns of data to get a third. Here is an example:
A B C
5 4
2 2
3 4
3 4
6 3
7 3
4 7
5 8
6 6
7 4
4 9
5 4
6 1
7 9
3 7
1 5
3 6
8 4
9 9
Is there a way I can get it to average the number in A and the number in B and display it in C? What about if I had more, could I get it to average the number in A, B, C, and D and get it to display in E?
On top of that, could I also get an average for all the numbers together?
Thanks a bunch guys.
I am trying to average two columns of data to get a third. Here is an example:
A B C
5 4
2 2
3 4
3 4
6 3
7 3
4 7
5 8
6 6
7 4
4 9
5 4
6 1
7 9
3 7
1 5
3 6
8 4
9 9
Is there a way I can get it to average the number in A and the number in B and display it in C? What about if I had more, could I get it to average the number in A, B, C, and D and get it to display in E?
On top of that, could I also get an average for all the numbers together?
Thanks a bunch guys.