title: Excel Formula to count rows in a column when a criteria is met in another column
body: <p>I have two sheets "Aug" &amp; "Dashboard."
  The "Aug" sheet it is always growing and it has multiple columns, but the important ones are "Week" (Week is in B3) and "Group" (in C3).</p>
  
  <p>I am able to do a formula that will count if any row in the "Group" column has the word "Harvest". =COUNTIF(Aug!C3:Aug!C1301,"Harvest")</p>
  
  <p>But, I would also like to be able to count the number of times Harvest shows up depending on the week and to put that information in a certain cell in the "Dashboard" Sheet.</p>
  
  <p>Here is what the "Aug" sheet could look like</p>
  
  <pre><code>Week Group 
  31   harvest
  31   harvest
  31   rqst
  31   harvest
  32   harvest
  32   harvest
  </code></pre>
  
  <p>The "Dashboard" sheet has a cell (A35) where you type in the week you want to look at.
  For example if I want the sheet to count how many times the word harvest shows up in week 31 then I would type 31 and I should expect the number 3 to turn up.</p>
  
  <p>I tried using a countif formula and an if formula, but that didn't work for me. Here is the formula that I tried using.</p>
  
  <p>=IF(Dashboard!A36=Aug!B4:AugB1301, COUNTIF(Aug!C4:Aug!C1302,"Harvest"))</p>
  
  <p>I get a #name! error.</p>
  
  <p>I then tried focusing on just one cell to see but I can't even get that to pull correctly.</p>
  
  <p>=IF(Dashboard!A36=Aug!B1302, COUNTIF(Aug!C4:Aug!C1302,"Harvest"))</p>
  
  <p>So What I understand from my formula is that If the number in cell A35 matches a the cell in the Aug sheet b1302, the it should count the entire column C and count how many times the word harvest comes up. 
  I keep getting a False statement.</p>
  
  <p>I can make the countif statement work on it's own. I can use the count if statement to give me a total of "harvest" in the entire column.</p>
  
  <p>I want it to count per the week i tell it to.</p>
  
  <p><a href="https://i.stack.imgur.com/CMQdK.png" rel="nofollow noreferrer">Snippet of my Dashboard sheet</a></p>
  
  <p><a href="https://i.stack.imgur.com/kXVwC.png" rel="nofollow noreferrer">Example of my Aug Sheet where I want to focus on just one cell</a></p>
  
  <p>And, if there is a VBA code that does this then it will be so much better because I will be able to have the formulas hidden.</p>
  
  <p>Thank you </p>