Formula that changes with filtered lists

[LukeM82]

I am using the following formula to obtain an overall score of customer satisfaction surveys in the attached example:

=((COUNTIF(I2:I314,"9 - Extremely Satisfied")*100)+(COUNTIF(I2:I314,"8")*100)-(COUNTIF(I2:I314,"5")*100)-(COUNTIF(I2:I314,"4")*100)-(COUNTIF(I2:I314,"3")*100)-(COUNTIF(I2:I314,"2")*100)-(COUNTIF(I2:I314,"1")*100)-(COUNTIF(I2:I314,"0 - Extremely Unsatisfied")*100))/(COUNTA(I2:I314))

I want to be able to get the score if I filter out certain dates and Locations. Right now when I do that, the score stays the same.

Is there a way to do this? Thank you for your help.

-Luke

[mikeTRON]

Why not make a pivot table like in the attached?