| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| About the usage of the function | Excel Worksheet Functions | |||
| Sumproduct() usage | Excel Discussion (Misc queries) | |||
| New Errors in Sumproduct Usage | Excel Worksheet Functions | |||
| limited usage | Excel Discussion (Misc queries) | |||
| 100% cpu usage | Excel Discussion (Misc queries) | |||
Hybrid Mode
