title: SUMPRODUCT with wildcard
body: <p>I have the <code>SUMPRODUCT</code> working with hardcoded values however I want to use a wild card for the B clomun in my example.</p>
  
  <p>Here is my data</p>
  
  <pre><code>+----------+----------+-----------+
  | A COLUMN | B COLUMN | C COLUMN  |
  +----------+----------+-----------+
  | Status   | Fruit    | Quanitity |
  |          |          |           |
  | Fresh    | Apple    | 6         |
  |          |          |           |
  | Fresh    | Apricot  | 7         |
  |          |          |           |
  | Stale    | Apple    | 4         |
  +----------+----------+-----------+
  </code></pre>
  
  <p>I would like to match <code>Fresh</code>, <code>AP*</code> and then sum the matches form Column C.</p>
  
  <p>I have the following</p>
  
  <pre><code>=SUMPRODUCT(--($B$2:$B$840="AP*"),--($A$2:$A$840="Fresh"),$C$2:$C$840)
  </code></pre>
  
  <p>Working code with the Wildcard but the count is off</p>
  
  <pre><code>=SUMPRODUCT(ISNUMBER(SEARCH"AP",$B$2:$B$840,1))*($A$2:$A$840="Fresh")*($C$2:$C$840))
  </code></pre>