sum
 

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

sum
 

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

sum
 

Another Option. Modify to suit

RowCount = Range("I41").CurrentRegion.Rows.Count
colISum = Application.Sum(Range(Columns("I").Cells(41, 1),
Columns("I").Cells(41 + RowCount - 1, 1)))

MsgBox RowCount & " " & colISum

--
Jay


"PCLIVE" wrote:

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

sum
 

Try =SUMIF($I$41:$I$2000,"<0",$I$41:$I$2000)
for a simplistic solution. Just be sure to set the range to always include
enough rows.
Use countif in similar fashion if you really need to count the rows. May
need to play with criteria if some values may equal zero.

"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