title: How to display zero in place of error in filter formula in google spreadsheet
body: <p>I am new to Google spreadsheet functions and trying to apply a formula in following way:</p>
  
  <p>I have <code>sheet1</code> &amp; <code>sheet2</code> in one workbook (name-formula4). I am doing sumproduct of filtered range from <code>sheet1</code> to <code>sheet2</code> with the following formula:</p>
  
  <pre><code>=SUMPRODUCT(filter(Sheet1!$A$1:$A$401, (Sheet1!$B$1:$B$401&gt;= E1) * (Sheet1!$B$1:$B$401&lt;= E2)))
  </code></pre>
  
  <p>Formula is perfectly ok when the range selected<br>
  <code>(Sheet1!$B$1:$B$401&gt;= E1) * (Sheet1!$B$1:$B$401&lt;= E2)</code><br>
  has some value &amp; is not empty. However if I leave the cells of said range empty (<code>sheet1!b1:b3</code>) -which are required to meet criteria- then this gives the error <code>No Matches are found in filter evaluation</code>. In a nut shell, I want to display <code>0</code> rather than displaying the error or <code>NA</code>.</p>
  
  <p>Note that I cannot fill entire the selected <code>B</code> column since this receives live data from the form and not previous decided which one.</p>
  
  <p>Please look at the following link for details and help in correcting the above formula:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1HTXf4VG2JupiP9UqCLRyAddYjhsom1leQOI9-DwfMaY/edit#gid=0" rel="noreferrer">https://docs.google.com/spreadsheets/d/1HTXf4VG2JupiP9UqCLRyAddYjhsom1leQOI9-DwfMaY/edit#gid=0</a></p>