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