title: Google Spreadsheet COUNTIF formula equivalent with two criteria
body: <p>I have a Google Docs spreadsheet with a few columns. In column D I have values Man OR Woman. In column G I have values Yes OR No. What I would like to to do is to count how many times MAN will answer with YES. So there are two criterias 1.Man and 2.Yes</p>
  
  <p>I have this formula which only counts values in cells D2 and G2. I would like to count values from D2 to D500 and from G2 to G500.</p>
  
  <p>=IF(AND('Revision: 2'!D2="Man",'Revision: 2'!G2="Yes"),1,0)</p>
  
  <p>How I can do that?</p>
  
  <p>Thank you!</p>