title: Google Sheets - IF ISBLANK QUERY
body: <p>I'm trying to come up with a formula to check whether a column where B='name' is empty or not. I'm using this formula if a cell is blank, add 50 points, if not, add 0 points.</p>
  
  <p>I have the basic formula of <code>=IF(ISBLANK(Sheet1!F8), 0, 50)</code> for a specific cell, but I want to query it for a name also. </p>
  
  <p>Here's what I got so far and it's giving me an error: </p>
  
  <pre><code>=IF(ISBLANK(QUERY(Sheet1!F, "select D where lower(B)='jennifer'") F) ,0, 50)
  </code></pre>
  
  <p><strong>EDIT</strong></p>
  
  <p>I'll explain the use a bit more to avoid confusion. </p>
  
  <p>Sheet1 is taking information from a Google Form being used for a points system. 
  The form asks for first name, last name, if they ran or volunteered for an event that month. There are individual sheets for each person who submits the form. The sheet "Jennifer" is the monthly and total points for her. </p>
  
  <p>What I'm trying to accomplish is check whether or not "Jennifer" participated in an event that month. The cell is either blank if they didn't, or has the event name in it if they did. If so, add 50 points for that month. Thus, if name="Jennifer" AND month="January" and cell is NOT blank, add 50 points. </p>
  
  <p>Current code is below, has no errors, but gives unwanted results:</p>
  
  <pre><code>=IF(ISBLANK(QUERY(Sheet1!A1:G, "select F where lower(B)='jennifer'and E='"&amp;B1&amp;"'")),0,50)
  </code></pre>