Morning folks.

I am trying to find the average value of heights for a plant database I have.

HEIGHT
Min-Max (Typical)
1-2.5' (2')
1-2' (2')
1-2.5' (2')
1-3' (2')
2.5-4' (3')
1-2.5' (2')
2.5-3.5' (3')
2-3' (3')

I15:I22

I want to be able to calculate the typical/average height of those species.