Thread: SUM while using filter function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote