SUMPRODUCT WITH WILDCARD

M

Mark

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!!
 
D

Dave Peterson

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

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

via135

hi!

SUMIF can use wildcards, but only for one test, but SUMPRODUCT doesn't
support wildcards directly.

-via135
 
M

Mark

Thanks Dave, but I'm getting #N/A and I can see there are some rows with this
info!

Can you offer any suggestion?
 
D

Dave Peterson

What formula did you use?

Do you have #n/a's in either of those two ranges?
Thanks Dave, but I'm getting #N/A and I can see there are some rows with this
info!

Can you offer any suggestion?
Click to expand...
 
Top