Is there a way to have Excel give totals for filtered data automatically when I filter the data?
S Skeeve1313 Jan 17, 2006 #1 Is there a way to have Excel give totals for filtered data automatically when I filter the data?
D Dave Peterson Jan 17, 2006 #2 I like to put my totals in row 1, my headers in row 2 and my data in rows 3:xxx. Then I can use =subtotal(#,xx:xx) in row one to get those nice subtotals. And =subtotal() will ignore those rows hidden by an autofilter.
I like to put my totals in row 1, my headers in row 2 and my data in rows 3:xxx. Then I can use =subtotal(#,xx:xx) in row one to get those nice subtotals. And =subtotal() will ignore those rows hidden by an autofilter.
G Guest Jan 17, 2006 #3 Hi Another way is to select the column for summing and, when the filter is applied, the total can be read in the status bar at the bottom right (or the average, count, etc) automatically. Change the filter, and the total changes. Andy.
Hi Another way is to select the column for summing and, when the filter is applied, the total can be read in the status bar at the bottom right (or the average, count, etc) automatically. Change the filter, and the total changes. Andy.
