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

Why don't you try it yourself before asking. Have a look at HELP index for
LEFT

--
Don Guillett
SalesAid Software
[email protected]
"marika1981" <[email protected]> wrote in message
news:[email protected]...
> 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

It's a simple LEFT

=PPCCo*SUMPRODUCT(--(LEFT(PPCName,3)="DNR"),--(PPCMonthRange=D$15),--(PPCYea
rRange=D$14),PPCImps)


--
HTH

Bob Phillips

"marika1981" <[email protected]> wrote in message
news:[email protected]...
> 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

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
> [email protected]
> "marika1981" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>