Quote Originally Posted by yeabocks View Post
I'm trying to write a formula for total rent paid over the term of a lease. So basically the total of years 1-15 above but using one formula.
Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread