And a variation that allows you to insert rows immediately
before the formula.
J72: =SUM(J$3:OFFSET(J72,-1,0))

see http://www.mvps.org/dmcritchie/excel/offset.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Gord Dibben" <gorddibbATshawDOTca wrote...
=SUM(J3:J71)

On Mon, 21 Aug 2006 18:50:51 -0700, ljsbjs wrote:
I need to the sum of one column - several rows.
Example: Column J rows 3 thru 71 without entering
each column and row number.