How do I count the number of times a row contains two specific words
<p>I am trying to put together a sales spreadsheet for my boss that counts how many times a specific sales rep has closed a deal.  One column would have a sales rep name, and another column would have the status of the customer.</p>

<p>So what I want is a total of how many times columns D (Sales Rep) and E (Status) contain both <code>Condie</code> and <code>Closed</code>.</p>

<p>I know you can use Len to count words, but I only want to count them if both D and E contain the necessary data.</p>