Im very new to Microsoft Excel (2016).
I have a data set where I want to average all of the data points from one column for a certain location. Example:
**Days Open** **Site**
Not Closed
Not Closed Boulder, USA
1 Boulder, USA
1 Boulder, USA
Not Closed Eden Prairie, USA
Not Closed Boulder, USA
4 Boulder, USA
Not Closed Boulder, USA
Not Closed Boulder, USA
Not Closed Boulder, USA
1 Boulder, USA
Not Closed Boulder, USA
Not Closed Eden Prairie, USA
Not Closed Boulder, USA
Not Closed Boulder, USA
7 Boulder, USA
Not Closed Boulder, USA
Not Closed Boulder, USA
Not Closed Boulder, USA
Not Closed Cluj, Romania
Not Closed Boulder, USA
Not Closed Nanjing, China
8 Boulder, USA
4 Boulder, USA
9 Nanjing, China
6 Boulder, USA
1 Boulder, USA
Not Closed Boulder, USA
Not Closed Boulder, USA
2 Nanjing, China
I want to completely disregard the "Not Closed" Data points.
My end goal would be to display say..
Boulder, 21
Nanjing, 18 ... etc
Each "Site" with all of their "Days open" Averaged.
Thank you!