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

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.

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

Use SubTotal(1,range)

Cordialy JB

On 19 fév, 13:22, Tammy W <Tammy
wrote:
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.

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

Sorry forgot the second bit, use
=SUBTOTAL(9, C1:OFFSET(C1000,-1,0))

for total


"Mike" wrote:

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
"Tammy W" wrote:

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.

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

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
"Tammy W" wrote:

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.