title: Excel AverageIf to get total average of multiple rows from a table
body: <p>I have provided a simple example of what I would like to do. I tried to use <code>AverageIf</code> to get the average of all Monday sales for March and April but the formula only provides me the average of March's Monday sales and excludes April.</p>
  
  <p>Note: <code>Column A is Weekday number, Column B is March Sales, Column C is April Sales.</code></p>
  
  <p>This is the formula I used:</p>
  
  <p><code>=AVERAGEIF(A2:A200, "=" &amp; 1, B2:C200)</code>, which only provides me with average Monday sales in column B.</p>
  
  <p>How can I adjust the formula to also include April in the total average (i.e. take into account column C rather than just column B alone)</p>