AutoSum and AutoFilter

  • Thread starter Thread starter Balazs - ExcelForums.com
  • Start date Start date
B

Balazs - ExcelForums.com

Hi, when I use an Auto Filter to sort and organize my data, I'd like
cell to perform an autosum on the Totals column.

However, when I use the drop down and pull up just one customer, i
still autosums the entire column, not just the columns that ar
returned by the filter

Any way of only getting the totals for just the columns that ar
filtered

Thank
Balaz
 
=SUBTOTAL(9,Range)
Hi, when I use an Auto Filter to sort and organize my data, I'd like a
cell to perform an autosum on the Totals column.

However, when I use the drop down and pull up just one customer, it
still autosums the entire column, not just the columns that are
returned by the filter.

Any way of only getting the totals for just the columns that are
filtered?

Thanks
Balazs
Click to expand...
 
=SUBTOTAL(9,A1:A100)

Hope this helps!
Hi, when I use an Auto Filter to sort and organize my data, I'd like a
cell to perform an autosum on the Totals column.

However, when I use the drop down and pull up just one customer, it
still autosums the entire column, not just the columns that are
returned by the filter.

Any way of only getting the totals for just the columns that are
filtered?

Thanks
Balazs
Click to expand...
 
Back
Top