mortgageman
Well-known Member
- Joined
- Jun 30, 2005
- Messages
- 2,015
I don't understand what the point of autofilter is if when you sum a filtered column, it sums the all the rows - filtered and non filtered.
For example:
Money Code
1 1
2 5
3 1
4 5
5 1
6 5
When I autofiltered on 5 and sumed the money column, I didn't get (as I thought I would) 12. I got the sum of the entire column. Why filter in the first place?
Gene Klein
For example:
Money Code
1 1
2 5
3 1
4 5
5 1
6 5
When I autofiltered on 5 and sumed the money column, I didn't get (as I thought I would) 12. I got the sum of the entire column. Why filter in the first place?
Gene Klein