title: Criteria across all range excel
body: <p>I am using average across a range but only want to take cells that:</p>
  <ol>
  <li><p>Are a number (isnumber())</p>
  </li>
  <li><p>Who's key match a particular string (form response = dataA)</p>
  <p>I am using</p>
  <pre><code>=AVERAGEIF('Form Responses 1'!$L$2:$L$143, AND(ISNUMBER('Form Responses 1'!L2), 'Form Responses 1'!C3=Data!A3))
  </code></pre>
  </li>
  </ol>
  <p>My issue comes from anything within the and() statement. How do I make sure that it compares and checks the appropriate cells?</p>
  <p>Cheers</p>