Unable to concatenate strings into excel countifs OR criteria
<p>I'm trying to utilize the syntax for <code>OR</code> like criteria for a <code>COUNTIFS</code> function in Excel. However, when trying use cell references, it just tells me </p>

<blockquote>
  <p>There is a problem with this formula</p>
</blockquote>

<p>Function: <code>=SUM(COUNTIFS(rosterTable[lastDayWithClient], {"&gt;="&amp;A7,""}))</code></p>

<p>Specifically if I'm trying to use <code>&amp;A7</code> to concatenate the criteria with a cell value, it fails.</p>