K KenCanuck Mar 19, 2009 #1 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
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 Mar 19, 2009 #2 =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>.
=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>.
