Thread
:
SUMPRODUCT WITH WILDCARD
View Single Post
#
1
Posted to microsoft.public.excel.misc
Mark
Posts: n/a
SUMPRODUCT WITH WILDCARD
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
Reply With Quote