title: How to add a condition inside criteria in excel?
body: <p>As an example, I want to have an averageIf and inside one of the criterias, criteria_range: H:H I want inside criteria a condition such as TEXT(H;&quot;mmm&quot;) = &quot;Jan&quot; to extract the month. Also tried something else but didn't work either:
  '=AVERAGEIF(TEXT(H:H;&quot;[$-409]mmm&quot;); &quot;Jan&quot;; K:K)</p>
  <p>Any idea?</p>
  <p>Thanks,</p>