MICROSOFT EXCEL
Calculate monthly totals
Excel makes it easy to calculate totals, but producing them for specific time periods requires a bit more work. In our example (see screenshot), we have a spreadsheet with dated sales. Our aim is to get monthly totals from these figures. To achieve this, we need two formulas: MONTH and SUMIF.
First, insert a column to the left of your dates – in our spreadsheet, this means clicking the header for (change ‘B2’ so that it matches the cell containing your first date). Now copy this formula into all subsequent cells in the new column. This column will now display the month number for each date (1 for January, 2 for February and so on ).