Cell formula: Sum that changes range

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.


Category: excel vba Time: 2016-07-29 Views: 0
Tags: excel vba

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.208 (s). 12 q(s)