title: Google Sheets, using Countifs to count number of values in a range, and match another cell's value
body: <p>Working on a Google Spreadsheet, seems to be behaving differently from excel.
  This spreadsheet is integrated from a Google form, responses have a date, and a username.
  What I am trying to do is count the number of entries between two dates, and submitted by a certain user.
  I.e. the sheet looks like this:<br>
    A      B            C<br>
  Timestamp  User         User Names<br>
  2/2/2015   Joe Jones    Joe Jones<br>
  2/12/2015  Steve Ahn    Steve Ahn<br>
  2/15/2015  Joe Jones<br>
  3/3/2015   Joe Jones<br>
  3/4/2015   Steve Ahn  </p>
  
  <p>I want to count the number of entries for Joe Jones between 2/14/2015 and 3/4/2015 i.e. return the result of 2 here.
  Here is what I have so far:<br>
  =COUNTIFS(A1:A15,">="&amp;I1,A1:A15,"&lt;="&amp;I2, B2:B15, C1)<br>
  But it throws an error "Array Arguments to COUNTIFS are of different size"<br>
  Each bit works as a countifs on its own.<br>
  Thanks!</p>