I have two columns:
A B
1 10
2 9
3 8
4 7
5 6
6 5
7 4
8 3
9 2
10 1
I need a formula that takes the difference of the two columns (1-10, 2-9, etc.) and then finds the average for all of the differences. I don't want to have a third column with the differences and then take the average of those. Any help would be much appreciated.
Thanks,
Steve
A B
1 10
2 9
3 8
4 7
5 6
6 5
7 4
8 3
9 2
10 1
I need a formula that takes the difference of the two columns (1-10, 2-9, etc.) and then finds the average for all of the differences. I don't want to have a third column with the differences and then take the average of those. Any help would be much appreciated.
Thanks,
Steve