Set formula to find last row of data

I have a formula that I need to keep changing as I add rows of data. How can I change this formula to always adjust itself to finding the last row of data when I add new rows? I read something about using the OFFSET function but not sure how to use it.


Open in new window

Lawrence SalvucciInformation Technology ManagerAsked:
Who is Participating?
barry houdiniConnect With a Mentor Commented:
If you have Excel 2007 or later I'd advise you to use SUMIFS which is faster. With that function you can just reference the whole columns with no significant downside, i.e.


If you really want to continue with the current formula then try looking at "dynamic named ranges", see here

regards, barry
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
Thanks Barry. I like your approach better.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.