Lost and Looking for Help
Guest
Summing a Field while Using an Autofilter
I have a large spread sheet that i must sort. I currently am using an
autofilter to sort the numbers, then copying the numbers to another sheet and
then summing those numbers. I am doing this because when using the
autofilter if you try and sum at the bottom of a column then you still sum
all the values that are hidden. Is there a way to just sum the visible
numbers when using the autofilter so that i can avoid having to copy and
paste to another sheet. This is really slowing down my program.
Bookmarks