A lot of very helpful posts. However, I have not seen this simoke question asked and answered.

I receive a lot of Excel files from various people I work with. When I have some column filtered and I manually sum the data (perhaps by just highlighting the column), on some spreadsheets the sum is the total of the filtered lines only while on others it is the sum of the total.

I assume there must be a basic difference in the two files that would cause this? What might that be? I'm assuming that if there is a basic differnece then I can easily change some setting in the file that still provides the sum of the total not the sum of the filtered items.

Yes? No? What are you, an idiot? Plese help and THANKS!