Getting a sum for only visible rows
Posted by Jim on June 21, 2000 8:08 AM
I have a list that will have autofilter enabled. I need to get the sum in one column of just the values that are visible after the filter. I figure I can do this with the SUMIF if I can put a formula in each row that will return a 1 or true if that row is visible.
Is there such a formula? Is there an easier way? I would prefer to do this without a macro, but will if necessary.
Thanks.