So what did you mean?

--
__________________________________
HTH

Bob

"wild turkey no9" wrote in message
...
Guys, thanks for your help. Apologies for my poor description.

"Glenn" wrote:

Bob Phillips wrote:
How can you multiply column B if it is letters?

Perhaps you want

=SUMPRODUCT((B2:B20={"E","N","D})(A2:A20))


I think "wild turkey no9" meant column B equals column E, column N or
column D...