SUM while using filter function

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
 
D

Dave Peterson

=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>.
 
Top