<div>
Thank you! &nbsp;Worked well.<br />
<br />
B.
</div>


<div>
I guess &nbsp;=SUBTOTAL(109,your range)
</div>


<div>
<div class="content wysiwyg-content">
EE Pros,<br />
<br />
Question; what formula (e.g. Sum) do I use if I want to only see the sum values for the records that are selected when I use filtering? &nbsp;If I have 100 records that = $100,000, and apply a certain filter on a column, I want only the value of the subset of records that are displayed.<br />
<br />
Thank you,<br />
<br />
b.
</div>
</div>


EE Pros,

Question; what formula (e.g. Sum) do I use if I want to only see the sum values for the records that are selected when I use filtering?  If I have 100 records that = $100,000, and apply a certain filter on a column, I want only the value of the subset of records that are displayed.

Thank you,

b.

Sum only Data Filtered

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.