Option 1
You can copy your formula down the entire column in anticipation of 65
thousand rows (or over 1 million, if in Excel 2007)

Option 2
Select the cell with the formula. Double-click the small square at the
bottom right of that cell and Excel will copy the formula down as far as you
have contiguous entries in column B

Option 3
Do you calculation of A-B in Access and import all three columns to Excel


"Bobby" wrote:

Hi,
I have a spreadsheet which is generated by an export from Access.
Column C does not come from Access and is a totals column, basically
Column A - Column B. I have put some conditional formatting on Column
C so that it is red if the value is negative and green if positive. I
have put a calculaion in Column C which is, "=sum(A1-B1)". I realise
that if I drag Column C down, then each cell will become "=sum(A2-B2)"
and "=sum(A3-B3)" etc.

However, my problem is I have no way of knowing how many rows will be
in the spreadsheet. It could be 10 or it could be 10,000. Is there
anyway that I can make Column C always reaslise that it will be Column
A - Column B on the same row, bearing in mind that row 1 is the
header and cannot be included in the calculation?

Thanks for your help

Bobby