Actually, the difference is correct. But how do I calculate each difference
of 2 numbers across for 2 columns of numbers down? For example, I have a
list of scores running down column A, and another list of scores running down
column B. I would like to calculate the differences between the two in
column C.

"David Biddulph" wrote:

I don't know what you mean by variance in this context.

The variance of A2:A100 is =VAR(A2:A100)
If you want the difference between A2 and B2 it is =B2-A2
--
David Biddulph

"copitta" wrote in message
...
I have two columns of scores. I need to calculate the variance
(difference)
across the two columns, with the result in column three. Seems simple but
I
cannot figure it out. Thank you.