I'm assuming you want your formulas to consider only the rows that pass the
filter. If so, check out the subtotal function; it honors the filter. Ex
=sum(a:a) will always give you the sum of the entire column.
=subtotal(9,a:a) will total those cells in column A that pass the filter.
See the help on the subtotal function to find the other calculations
available in subtotal (min, max, avg, count, etc).

"Jo Davis" wrote:

Hi

Can you have a formula that updates when you use a filter?