Filtering and Totals

P

Paul Sheppard

I am using excel 2000

I have a spreadsheet with 21 columns and 200 rows of data in row 20
are totals for columns 14 to 19

Column A contains names of Area Managers of which there are 10

If I filter on column A the totals in row 201 are hidden,

is it possible to filter and either still have the totals showing o
for the totals to reflect just the data showing as a result of th
filter

I've tried adding subtotals, but again when I filter the total
disappear

Any help greatly appreciate
 
G

Guest

I use a "Freeze line" say at row 8, and put my formula ABOVE that line, to
total a column, and use the SUBTOTAL function as it ignores hidden rows.

hth
Vaya con Dios,
Chuck, CABGx3
 
G

Guest

Are you wanting to see all of the data in the rows that relates to the Area
Managers or just the totals? Could you perhaps use a Pivot Table to filter
out the data you want?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Column Totals - XL2003 5
Excel Subtracting multiple columns from another column 3
Totals in my filtered worksheet 1
Filters and totals 14
An odd problem with SUM(A:B) and AutoSum 2
Excel 2003 Pivot Table - Grand Total 4
Limit the number of rows for a filter 3
lookup using column headers and row headers 1

Top