title: Excel - Sum column if condition is met by checking other column in same table
body: <p>I am trying to create spreadsheet to use in a small retail shop. </p>
  
  <p>I have a workbook which contains expenses figures on a sheet and income figure on another sheet. </p>
  
  <p>We can say that the common ground between the both sheets are the month.</p>
  
  <p>I would like to write a function, which will only select those expenses of a specified month. </p>
  
  <p>Something like - </p>
  
  <pre><code>=SUM(IF( Table4[Month]="January", Table4[Amount])) 
  
  // I want the sum of all expenses of a given table for only 
  // those months which are january etc.
  </code></pre>
  
  <p>I tried using the above, but it failed.</p>