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