Autofilter lenght out of control, how to fix

[acounter2]

How to control autofilter range in Excel 2003?
I have columns A,B,C, where A is date, B - customer, C sum
When I choose autofilter value in B the sum row in C is cut off and the same table 1 year earlier version does not hide the sum row.

I have experimented filling in column A with values up to the row of sum or inserting empty row(s) to indicate where I'd like to stop auto filter but now help.

While old spreadsheet version seems to be rather tolerant to these changes.
Any ideas how to control autofilter stop (range) row?

Thanks!

MS Office 2003, W7 x64.

 

[GlennUK]

It sounds like your earlier version had a subtotal of some kind, whereas you've typed a SUM formula which Excel is treating as part of the filter. What formula is used in your earlier version for the summing?

 

[acounter2]

Thnks for help. Now it works.
I did some more test and it appears that first column determines the lenghts of autofilter range, as expected. But when deleting from first row the last row entries using delete key, autofilter still doesn't see these as empty. Instead I had to select whole row(s) and to use Edit->Delete row command and I also recreated sum formulas.

1. I like to use End->Arrow down in first column to reach the end of table with sum visible.
2 To use autofilter I have to create additional subtotal(9) formula below it.

And to keep in mind that in Excel "Delete" occasionally doesn't delete all cell content