SUMPRODUCT usage
 

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

SUMPRODUCT usage
 

How can you multiply column B if it is letters?

Perhaps you want

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

--
__________________________________
HTH

Bob

"wild turkey no9" wrote in message
...
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

SUMPRODUCT usage
 

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

SUMPRODUCT usage
 

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

SUMPRODUCT usage
 

Or, use€¦€¦

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

Regards
Bosco


"wild turkey no9" wrote:

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

SUMPRODUCT usage
 

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