And I forgot the singleton L, too.

Dave Peterson wrote:
>
> Maybe...
>
> =SUM(SUMIF($D$5:$D$156,{"ee","e","m","ll"},$U$5:$U$156))
>
> Gunjani wrote:
> >
> > 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
>
> --
>
> Dave Peterson

--

Dave Peterson