Maybe one way:

=SUM(INDIRECT("I41:I"& 40+COUNTA(A41:A65536)))

Regards,
Paul

"jln via OfficeKB.com" <u25956@uwe wrote in message
news:68fe7c8c800d9@uwe...
OK what i have is a spread sheet that starts on line 41 and goes down.
What i need to do is count how many rows from 41 down and then sum just
column I.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1