one way where 999999 is larger than any number possible to sum last -3=last
4 rows
=SUM(INDIRECT("f"&MATCH(999999,F:F)-3&":f"&MATCH(999999,F:F)))

--
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