hi!

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

-via135

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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=521504