<div>
quick response. perfect answer!
</div>


<div>
<div class="content wysiwyg-content">
I have a <a href="https://docs.google.com/spreadsheet/ccc?key=0Am5eEooQEL63dHJVQXB5aTVwaHdxZVMtUjBMTTBNNmc&usp=sharing" rel="ugc">google spreadsheet</a>.<br />
<br />
If i specify the actual name of a named range in a formula, my formula works, see cell h11. &nbsp;If i specify a cell that contains the name of a named range in the formula, it doesn't work, cell h12.<br />
<br />
If someone could help me create a formula based upon a dynamic range, that would be great!!.<br />
<br />
Please help me get my formula working. &nbsp;thank you.
</div>
</div>


I have a google spreadsheet (https://docs.google.com/spreadsheet/ccc?key=0Am5eEooQEL63dHJVQXB5aTVwaHdxZVMtUjBMTTBNNmc&usp=sharing).

If i specify the actual name of a named range in a formula, my formula works, see cell h11.  If i specify a cell that contains the name of a named range in the formula, it doesn't work, cell h12.

If someone could help me create a formula based upon a dynamic range, that would be great!!.

Please help me get my formula working.  thank you.

dynamic range in formula

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.