How to Sum by Year in Google Sheets

To sum by year in Google Sheets, you can use a combination of the SUMIFS and YEAR functions. Here's a step-by-step guide on how to do this:

1. Prepare your data: Make sure your data is organized in a table format with separate columns for dates and values. For example, you might have a column with dates (Column A) and another column with amounts or values (Column B).
2. Create a summary table: In a separate area of your sheet, create a summary table with a column for the years you want to sum. For example, you can list the years in Column D, starting from cell D2.
3. Use the SUMIFS and YEAR functions: In the cell adjacent to the first year in your summary table (E2, for example), enter the following formula:

=SUMIFS(B:B, A:A, ">="&DATE(D2, 1, 1), A:A, "<="&DATE(D2, 12, 31))

This formula sums the values in Column B if the corresponding date in Column A is within the specified year in cell D2.

4. Copy the formula down: Click on the cell with the formula (E2), and then drag the fill handle (the small blue square in the bottom-right corner of the cell) down to fill the cells adjacent to the other years in your summary table.

Example

Here's an example to illustrate the process:

1. Your data table:

2. Your summary table:

3. Enter the formula in the Total column:

In cell E2, enter the following formula:

=SUMIFS(B:B, A:A, ">="&DATE(D2, 1, 1), A:A, "<="&DATE(D2, 12, 31))

4. Copy the formula down to E3.

Your summary table should now look like this:

This table shows the sum of amounts for each year.