Re: Calculating averages in sorted columns

If you filter, that means some would be hidden , so use the 100+ range of
function_num

=SUBTOTAL(101,A1:A100)

--
__________________________________
HTH

Bob

"T. Valko" <biffinpitt@xxxxxxxxxxx> wrote in message
news:%231yKsef9IHA.5756@xxxxxxxxxxxxxxxxxxxxxxx
You want to use the SUBTOTAL function.

Look in help for SUBTOTAL. It has many variations depending on your needs.
For example, to get an average of filtered data in the range A1:A100 -

=SUBTOTAL(1,A1:A100)

--
Biff
Microsoft Excel MVP


"Nathan" <Nathan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:72A2E570-707C-446D-835E-F604AEF656CE@xxxxxxxxxxxxxxxx
Hi,

I have a spread*** of a survey I conducted with teachers at various
schools. Across row 3 I have Name, School, and then all of the questions.
In
row 4 down, I have all of the data. In row 2 I would like to calculate
averages for all of the answers. I am sorting (through auto filter) the
data
by school, and would like to enter an average formula that adjusts every
time
I sort by a different school. I think this uses an IF function, but am
not
sure. Any thoughts?

Thanks, Nathan.




.