=sumproduct(--(left(f1:F100,3)="npt"),--(left(a1:a100,2)="pc"))

You can't use whole columns with this kind of formula.

Mark wrote:

Can someone assist me with a formula to sumproduct with wildcards, please?

=SUMPRODUCT(--(F:F="NPT*"),--(A:A="PC*"))

I've got this but it doesn't work!!

--
Mark

--

Dave Peterson