You could use a helper column to set a value based on the contents o
the cells, e.g.:

=CHOOSE(MATCH(A1,$F$1:$F$4),4,5,2,10) copied down in col B with you
list of criteria in F1:F4 (ms,s,p,j) would read the cells in Col A an
return the listed values or #N/A if not matched.

Then =AVERAGE(Bn:Bnnn) gives you the average of this range

Does this work for you

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=48101