ExcelBanter - SUM while using filter function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SUM while using filter function (https://www.excelbanter.com/excel-discussion-misc-queries/224939-sum-while-using-filter-function.html)

KenCanuck

SUM while using filter function

WHat function can I use that will give a sum of only the displayed data when
using the filter function on a list of data? Thanks

Dave Peterson

SUM while using filter function

=subtotal(9,a2:a99)

=subtotal() has lots of options for that first argument--you can count, count
numbers, average, ...

Excel's help will help <bg.

KenCanuck wrote:

WHat function can I use that will give a sum of only the displayed data when
using the filter function on a list of data? Thanks

--

Dave Peterson

All times are GMT +1. The time now is 04:08 PM.