Conditionally sum variable dataset

I would like help with the following:

I have a spreadsheet which has general usage and summary data at the top for ease of use. Begining at Row 15 the data is a standard table which includes columns for the following
Cust Name | Status | Loan Amt | etc.

I have created a macro to make it easier to add new data rows at the top of the data already in the file (this makes it easier to view with the newest data at the top). I would like to create a conditional sum of the data in "Loan Amt" if the value in "Status" ="Active". I had no problem achieving this with the conditional sum tool but the problem is that the range changes whenever a new row is added to the top of the list. Unfortunately the range in the conditional sum adjusts as the old data shifts down for the new row and the sum does not contain the new row data.

Any suggestions on how to state the conditional sum so it will always include the new data that is added to the table?

By "conditional sum" are you referring to SUMIF ?

You can use INDEX to keep start point fixed, eg:

Please Login or Register  to view this content.

modify B20 / C20 to be the last row of data as at now - these will adjust as you add new data into your table whereas the references to row 15 will remain fixed.