title: Only add cells in column when the total of multiple other cells in that row equals 5
body: <p>So I am getting data fed into a spreadsheet on Google Sheets. I cannot edit that spreadsheet.</p>
  
  <p>I have an additional sheet in the document that totals up the columns in this sheet. The sheet received info such as:</p>
  
  <pre><code>  A  B  C  D        This info is not actually in the sheet
  |------------|        \/    \/
  | 4  1  0  0 |      &lt;-- Valid
  | 3  1  1  0 |      &lt;-- Valid
  | 3  1  0  2 |      &lt;-- Invalid
  | 3  0  1  1 |      &lt;-- Valid
  |------------|
  </code></pre>
  
  <p>The total of each individual row should be 5, but I do not currently have a way of validating this in the form itself. So I need to disregard or remove the data if it is in violation.</p>
  
  <p>So basically, I want to add all the values of column A together, but only of the rows in which the total of these 4 cells are exactly 5; No more, no less.</p>
  
  <p>The furthest/closest I have gotten was using SUMIF, but the I need a single cell indicating whether or not the row totals up to 5, and as I said before, I cannot edit the cells in that specific sheet.</p>