title: Google Sheets Import Data and COUNTIF?
body: <p>I am using google sheets and trying to Import Data from another sheet into the current sheet, but looking for this imported data to pull certain values.  </p>
  
  <p>For example, I need to know how many incomplete assignments were submitted by males.  This is what I have thus far...which is not working.  I am getting the answer of 4 when I should be getting 2. "Incomplete" is in column A,  Male is in K </p>
  
  <p>For example:  =COUNTIF(IMPORTRANGE("Key","Sheet!A:A"),"=Incomplete")*(COUNTIF(IMPORTRANGE("Key","Sheet!K:K"),"=Male"))</p>
  
  <p>Also, I need to extend this further and be able to calculate how many students had an excuse for not completing the assignment.  I do not need to know the actual reason, I just need to know if there was an excuse.  Not applicable is an option, but needs to be ignored.  This is what I have thus far, but it will only recognize the first answer, not the rest.</p>
  
  <p>=COUNTIFS(IMPORTRANGE("Key","Sheet!N:N"),{"Absent";"Illness";"Social Issues";"The Dog Ate It";"On Holidays";"Not Interested";"Bored"})</p>
  
  <p>Any assistance greatly appreciated.</p>
  
  <p>Billy</p>