title: Get total figure from multiple figures in Excel
body: <p>I have a spread sheet with data on it that I am trying to add up to get a grand total for each week and month.</p>
  
  <p>The data is displayed within a single sheet/tab on excel that has a date column and goes back to lets say 1st December. What im trying to do is add each total up to basically get a weekly and monthly figure instead of a figure for each individual day.</p>
  
  <p>For example sake lets say im trying to add up the weekly total of apples picked for each person.</p>
  
  <pre><code>A1 = EMPLOYEE ID
  B1 = DATE APPLES WERE PICKED 
  C1 = how many apples were picked on that 1 day
  </code></pre>
  
  <p>The hard bit is there is 100 people each day picking these so its hundreds of lines of data.</p>
  
  <p>Im wanting to get a total weekly amount for each person but its hard to do as there are too many employees so I cant do it by manually working it out</p>
  
  <h2>Output basically looks like that</h2>
  
  <pre><code>A1 20332332
  B1 FROM 10/2/16 - 17/02/16
  C1 312 (APPLES PICKED)
  A2 888865
  B2 FROM 10/2/16 - 17/02/16
  C2 222 (APPLES PICKED)
  </code></pre>