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