Average of letters

[yokosangi]

Hi,

I am stuck here and would really appreciate some help.

I have a sheet holding rawdata, were some columns contains only a letter on each row, A-F. The A-F is a rating scale, and each letter is "replaced" by a certain number via "IF(ISNUMBER(SEARCH("A";Segment!T31));"10"; etc etc)".
There are multiple rows/units within each column, and I want to have the average value of all letters within that column. Problem is that i cant get excel 364 to accept the "IF(ISNUMBER...." above as numbers, so it is not possible to use the AVERAGEIF formula on that column. Is there any fix on this, or maybe an even easier way to get that?

Many thanks in advance

 

[Fluff]

You need to remove the quotes from the 10, otherwise it's text & not a number.