A (very little) bit shorter:
=((COUNTIF(E20:J20,"a")+COUNTIF(E20:J20,"I"))*10+( COUNTIF(K20:P20,"a")+COUNT
IF(K20:P20,"I"))*20+(COUNTIF(Q20:S20,"a")+COUNTIF( Q20:S20,"I"))*30+(COUNTIF(
T20:W20,"a")+COUNTIF(T20:W20,"I"))*20)/2

since the SUM function is unnecessary

HTH
--
AP

"natei6" a écrit dans
le message de ...

Hi to all,


=SUM(((COUNTIF(E20:J20,"a")+COUNTIF(E20:J20,"I"))* 10+(COUNTIF(K20:P20,"a")+C
OUNTIF(K20:P20,"I"))*20+(COUNTIF(Q20:S20,"a")+COUN TIF(Q20:S20,"I"))*30+(COUN
TIF(T20:W20,"a")+COUNTIF(T20:W20,"I"))*20))/2

This formula that I have put together gets the desired result, but I am
seeking a simpler version. Many thanks.
Nate.


--
natei6
------------------------------------------------------------------------
natei6's Profile:
http://www.excelforum.com/member.php...fo&userid=7185
View this thread: http://www.excelforum.com/showthread...hreadid=531425