close
What if I want to qualify it more with where one column looks for heather and
the other looks for b or eb. Can I use a wildcard * in sum product
No need for wildcards
=SUMPRODUCT(--(A2:A20=quot;heatherquot;),--(ISNUMBER(MATCH(B2:B20,{quot;bquot;;quot;ebquot;},0))))
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
quot;Robquot; gt; wrote in message
...
gt; What if I want to qualify it more with where one column looks for heather
and
gt; the other looks for b or eb. Can I use a wildcard * in sum product
全站熱搜
留言列表
