title: Attempting to fashion (Google Sheets)...IF search within a range is true, COUNT all occurances of search in the range AND decrease by 1, if false, 0
body: <p>Example long hand formula:<br />
  IF &quot;text_1&quot; [a cell reference] appears in this range [a column range], COUNT all occurances of &quot;text_1&quot; in the range and decrease by 1, if &quot;text_1&quot; [the cell reference] does not appear, 0.</p>
  <p>I've tried:  =countif(C$2:C$15,$A17)-1  YET, when A17 does not appear in C2:C15, the result is -1.  I need 0.</p>
  <p>Any assistance would be greatly appreciated.  Thanks!!</p>