Or better
=SUM(OFFSET($F$1,COUNT($F$1:$F$1000),,-4,))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
ups.com...
I have a table that is constanty being updated from a connection to a
text file. Right now I'm using a SUMPRODUCT formula to summarize the
entire table based on certain values in the data. I want to change
this so I'm only looking at the last n rows. What would be the best
way to accomplish this ?

Thank-you

Jeff