Hi

P.e. with data you want to calculate the average of in range A2:A100, enter
into some cell not on same row with your data (p.e. you can use additional
rows in table header for it) the formula:
=SUBTOTAL(1,A2:A100)
Now use autofilter to filter all check values equal to 1, and you'll get the
average of filtered data returned by formula.


Arvi Laanemets



"Flutie99" wrote in message
...
I have some data that I like to select and deselect using 1 or 0,
respectively. I'd like to look at the average of the values of the
numbers I
select using 1. Essentially, I am looking for an "averageif" function.