I'm working on a spreadsheet that adds the customer's individual orders up to create the total due. Suffice to say, the number of orders changes. So I was wondering if there was any way to have the cell add a specific range above it, so to speak. For example, the cell formula changes depending upon a number of orders (i have that number) and then adds the cells that number above it. For example, if the customer had 2 orders, the cell ( D45, for the exampl) would have the formula "=Sum(D43:D44)" but that formula would change when rg got to the next place where it needed to add a different order. I could just add them and equate the value in that cell to that, but I want to be able to change those numbers and that total dynamically. Thanks in advance.