Hi,

I have a sheet which contains many accounts in one column and amounts paid
in another column,I really dont need the auto filter which places a filter on
every column.How do you make a filter for the account column and at the same
time have a total for the amounts paid column when the filter shows only
those accounts?