SUM while using filter function

  • Thread starter Thread starter KenCanuck
  • Start date Start date
K

KenCanuck

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
 
=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>.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sum function in an Access Form 1
Filtering with SUMIFS 1
sum visible 1
Adding functions to filters 2
Filtering problem 1
SUBTOTAL not refreshing when using advanced filter 2
Applying formulas to filtered data 4
Excel 1

Back
Top