Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LEFT embedded in SUMPRODUCT
Hi,
I'm currently using the formula =PPCCo*SUMPRODUCT(--(PPCName="DNR"),--(PPCMonthRange=D$15),--(PPCYearRange=D$14),PPCImps) I would like to change the first SUMPRODUCT argument so that it accepts any cel that STARTS with "DNR", not simply equals "DNR". I presume it would be by using the LEFT command, but I'm not sure how that syntax works here. Any suggestions would be greatly appreciated!!! Marika :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LEFT embedded in SUMPRODUCT
Why don't you try it yourself before asking. Have a look at HELP index for
LEFT -- Don Guillett SalesAid Software "marika1981" wrote in message ... Hi, I'm currently using the formula: =PPCCo*SUMPRODUCT(--(PPCName="DNR"),--(PPCMonthRange=D$15),--(PPCYearRange=D $14),PPCImps) I would like to change the first SUMPRODUCT argument so that it accepts any cel that STARTS with "DNR", not simply equals "DNR". I presume it would be by using the LEFT command, but I'm not sure how that syntax works here. Any suggestions would be greatly appreciated!!! Marika :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
LEFT embedded in SUMPRODUCT
It's a simple LEFT
=PPCCo*SUMPRODUCT(--(LEFT(PPCName,3)="DNR"),--(PPCMonthRange=D$15),--(PPCYea rRange=D$14),PPCImps) -- HTH Bob Phillips "marika1981" wrote in message ... Hi, I'm currently using the formula: =PPCCo*SUMPRODUCT(--(PPCName="DNR"),--(PPCMonthRange=D$15),--(PPCYearRange=D $14),PPCImps) I would like to change the first SUMPRODUCT argument so that it accepts any cel that STARTS with "DNR", not simply equals "DNR". I presume it would be by using the LEFT command, but I'm not sure how that syntax works here. Any suggestions would be greatly appreciated!!! Marika :) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
LEFT embedded in SUMPRODUCT
Well, I certainly did that and tried many syntax variations, but I need some
help. Its inclusion within the syntax of the SUMPRODUCT formula is making it more complicated for me. Do I still use an equal sign? Does it require an IF because its a lookup? Apologies for frustrating you..... I'd be quite grateful for any help or suggestions, Marika "Don Guillett" wrote: Why don't you try it yourself before asking. Have a look at HELP index for LEFT -- Don Guillett SalesAid Software "marika1981" wrote in message ... Hi, I'm currently using the formula: =PPCCo*SUMPRODUCT(--(PPCName="DNR"),--(PPCMonthRange=D$15),--(PPCYearRange=D $14),PPCImps) I would like to change the first SUMPRODUCT argument so that it accepts any cel that STARTS with "DNR", not simply equals "DNR". I presume it would be by using the LEFT command, but I'm not sure how that syntax works here. Any suggestions would be greatly appreciated!!! Marika :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use Sumproduct with the LEFT Function? | Excel Worksheet Functions | |||
VLOOKUP function with embedded LEFT | Excel Worksheet Functions | |||
=SUMPRODUCT(--(LEFT Bob Phillips | Excel Discussion (Misc queries) | |||
SUMPRODUCT AND LEFT | Excel Worksheet Functions | |||
Left and Sumproduct | Excel Discussion (Misc queries) |