1) Type formula into one cell
2) Hit Enter (to make sure it works properly)
3) Go back and click on the cell you just entered the formula in. Now that
cell is selected.
4) Place mouse over bottom right corner of cell (little black square)
4) Click and drag as far down as you want to copy the formula, and it will
automatically paste the formula.

Let me know if these direction were clear enough.

"nitenurse" wrote:

> Sort of going through all 140 rows and typing the formula individually, how
> do I get data from two columns to average, or find diferences. I know how to
> do it manually but surely there is an easier way. The books all show how to
> work with columns but how do you work with multiple columns?