Hi,
I have a large spreadsheet with multiple columns using 'Auto Filter'. Many of the columns are sum totalled at bottom. Can anyone tell me how to have the totals adjust according to the filter data. Simply using standard sum and auto filter functions doesn't work. No matter how much data I filter out the totals don't change.
Any help appreciated/ideas, thanks.