If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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... |
#4
|
|||
|
|||
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... |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|