title: Excel SUM dynamic range returned from database
body: <p>I am new to excel and I am trying to write an excel formula where I sum all the values from a single column. The data is returned from a .net application so I am using a template file and each column as a suffix which is <strong>%%=sso.qty</strong> for example. So its only when a report is run through the application that there is actual data in each column.</p>
  
  <p>I want a formula which will dynamically add all values in a column regardless of cell range. So if my suffix is in cell K10 how would the formula know to adjust the range based on how many rows of data there is?</p>
  
  <p>Does anyone know a good way of doing this?</p>