How to use CountIF and VlookUps properly.

For getting the count of stores which is achieving the 95%

Formula:

=COUNTIF(Store!O8:O646,">="&D31)

In G31 Cell - To get the average of stores matching the 95% - Format the cell as %

Formula:

=AVERAGEIF(Store!O8:O646,">="&D31,Store!O8:O646)

In the suggested Array formula just replace the = with >= and drag it down to get the region of stores.