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 :)

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 :)

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 :)

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 :)