Looking to find the average of cells with both letters & numbers.

[RJ_B]

I'm trying to find the average number of the maximum speed of 1000+ entries. I'm also trying to find the maximum distance travelled, in a different column, which also contains numbers & letters. Obviously going through 1000 separate cells isn't feasible, and I cannot seem to find the correct formula to do this. I only get errors using base formulas, so require a custom one. How can this be achieved? I'm not sure if this makes sense, but please reply if you require further explanation.

 

[kweaver]

Welcome to Mr. Excel,

Please update your profile to indicate what version of Excel you are running.

If you use XL2BB with sample data AND expected results, those trying to help you don't have to retype the data examples.

 

[RJ_B]

I'm not using excel, I'm using google sheets, I did put the tag for google sheets into this ticket to indicate that. Is XL2BB compatible with sheets?

 

[kweaver]

I'm not using excel, I'm using google sheets, I did put the tag for google sheets into this ticket to indicate that. Is XL2BB compatible with sheets?

Please note that for this forum: Do not post questions about other spreadsheet programs (e.g. Google Sheets) in this forum.
Use this one:
https://www.mrexcel.com/board/categories/question-forums.3/