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.