Currently I am using the following formulae

=SUMIF($D$5:$D$156,"=EE",$U$5:$U$156)
=SUMIF($D$5:$D$156,"=E",$U$5:$U$156)
=SUMIF($D$5:$D$156,"=M",$U$5:$U$156)
=SUMIF($D$5:$D$156,"=L",$U$5:$U$156)
=SUMIF($D$5:$D$156,"=LL",$U$5:$U$156)

Then SUM all the above to get the overall total. How can this be
simplified to one formula.

I have tried the folloing but with no joy

=SUMIF($D$5:$D$156,"=EE,E,M,L,LL",$U$5:$U$156)
=SUMIF($D$5:$D$156,"=EE","=E","=M","=L","=LL", $U$5:$U$156)
=SUMIF($D$5:$D$156,OR(EE,E,M,L,LL),$U$5:$U$156)

but none of the above work.

any suggestions
Thx
Gunj