SUMPRODUCT usage

[wild turkey no9]

Hi There

Is there an easy way to configure sumproduct to do the following:

multiply col A * Col B when col B = either E or N or D

Thanks

Kevin

 

[Bob Phillips]

How can you multiply column B if it is letters?

Perhaps you want

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

 

[Glenn]

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...

 

[wild turkey no9]

Guys, thanks for your help. Apologies for my poor description.

 

[bosco_yip]

Or, use……

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

Regards
Bosco

 

[Bob Phillips]

So what did you mean?