How do I get an average of filtered data in an excel database?

T

Tammy W

I am trying to set up a sales database but I want to filter the information
and get a total and average for example for one particular sales person and I
am a bit stumped as to how to set this up? I have set up the formulas to get
an average but when I filter it doesn't update?

Thanks for your help in advance.
 
M

Mike

Try
=SUBTOTAL(1, C1:OFFSET(C1000,-1,0))

Where C1 is the top of your range and C1000 is below the bottom of the
unfiltered range.

Mike
 
Top