title: Counta + Filter function on Google spreadsheet cannot give me a Zero
body: <p>I am trying to use FILTER and COUNTA in Google spreadsheet.
  <a href="http://i.stack.imgur.com/EXyUu.png" rel="nofollow">Spreadsheet</a></p>
  
  <p>The formula in E1 is =COUNTA(filter($A$1:$A$12,$A$1:$A$12>=$C1,$A$1:$A$12&lt;=$D1))</p>
  
  <p>This formula help me to filter and count the date (Column A) which is within the date range (Column C and D).</p>
  
  <p>The result in E1 and E2 is correct. However, E3, E4, E5 do not give me a zero, as there is no date fit in the range.</p>
  
  <p>Anyone can help me on this to make it return a Zero if there is no date fit in the date range?</p>