Thanks so far for all the help.
I'm using the formula =COUNTA(b17:b430) in cell C3 to give me the number of
addresses in a column. I'm using an autofilter in the chart and when I
perform a filter, the value in C3 stays the same. I would like the function
to add only what remained after the filter. Is there a way to do this? Any
help is appreciated. Thanks.