Finding Averages in Cells with Text and Number

Here's a possibility.



If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.

An alternative Using the same layout as skywriter...:

=AVERAGE(--LEFT(MID(A3:A10,FIND("(",A3:A10)+1,255),FIND(")",MID(A3:A10,FIND("(",A3:A10)+1,255))-2))

This is an Array Formula. They're a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

I notice that you have marked this as solved. As a matter of interest, which one did you use?

Glad to have helped! It'd be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.