Can formulas work just on filtered data?

[fbarbie]

I have raw data in one worksheet. In another worksheet, I want to calculate an average of the values in one column in the data worksheet.

I would like the average to be calculated on only certain data. Can formulas work on only the values that remain after a column has been filtered by the autofilter function?

Thanks.g

[Domenic]

You can use the SUBTOTAL function...

=SUBTOTAL(1,Sheet1!A1:A100)

The SUBTOTAL function can also be used for other types of calculations. See the help menu.

Hope this helps!

[fbarbie]

Man, you don't know how many expletives I'm shouting for joy because of this. Thank you! Excel and this forum rock.