How do I get formulas to recalculate based on only the visible data after
using the AutoFilter function in Excel 2000? I'm using the COUNTIF and
COUNTA functions to determine a percentage using two separate cell ranges and
I want to be able to filter the data in those ranges and have the formula
recalculate based on the filtered data.