title: Excel SUMIF column value matches
body: <p>I would like to sum all values in column J when the value in column K matches. So, for example, I have the following:</p>
  
  <p>COL J | COL K <br>
  25.00   | Now<br>
  45.00   | Aug 15<br>
  40.00   | Sep 10<br> 
  70.00   | Now<br>
  14.00   | Aug 15<br>
  92.00   | Now<br></p>
  
  <p>I'd like Excel to find all matching values in Column K and add up the values in corresponding rows of column J. For the example above it would sum 25.00, 70.00 and 92.00 which correspond with "Now" and then also add up 45.00 and 14.00 which correspond with Aug 15.</p>
  
  <p>I know it can be done with formulas like this:<br>
  =SUMIF(K:K,"Now",J:J)<br>
  =SUMIF(K:K,"Aug 15",J:J)</p>
  
  <p>However, I'd like to be more flexible and not have to have a separate formula for every different value in Column K. Is there a way to use a wildcard of some sort that can replace "Now" and "Aug 15" in the example above so that I could just have one formula that finds any matches in Column K and sums the corresponding values for those rows in Column J?</p>
  
  <p>Thank you!</p>