title: COUNTIFS referencing another sheet
body: <p>My Fourmula: <code>=SUMPRODUCT(COUNTIFS(BRIDGE!H2:H500,"&gt;50",H2:H500,"&lt;75" ))</code></p>
  
  <p>Trying to count values greater than 50 but less than 75 on another sheet named "Bridge". The problem, this is just counting on the sheet the formula is on, not the referenced sheet. What am I doing wrong? </p>