Excel Formulas to Sum the Values by Year using SUMIFS!!
Tags: excelformula, excelformulas
Published: 2020-11-27 09:11:13

---
title: Excel Formulas to Sum the Values by Year using SUMIFS!!
published: true
date: 2020-11-26 11:56:01 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-sum-the-values-by-year-using-sumifs/
---

Here, we will guide you to learn the simple **formulas used to sum the values by year in Excel Office 365**. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

!["Formulas](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Formulas-to-sum-the-values-by-year.png)

## General Formula:

- Use the below formula to sum the values by year in Excel.

**=SUMIFS(sum\_range,date,”>=”&[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([year](https://geekexcel.com/how-to-use-year-function-in-excel-365/)),date,”<=”&DATE(year,12,31))**

## Syntax Explanations:

- **SUMIFS** – The Excel **SUMIFS Function** will help to sum the cells that meet multiple conditions or criteria.
- **DATE** – It combines three different values and returns them as a date. Read more on the [**DATE Function**](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/).
- **YEAR** – The Excel [**YEAR function**](https://geekexcel.com/how-to-use-year-function-in-excel-365/) returns the year component of a date as a 4-digit number
- **Criteria (Year)** – It is the specific year that is used to sum the cells.
- **Sum\_Range** – It represents the input values given in the worksheet.
- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Let’s consider the below image to sum the values by year.
- First, you need to give the input dates and values.
- Refer to the below image.
- In this example, we will give the input date and amount in **Column C** and **Column D**.
- Then enter the given formula in the formula bar section.
- Finally, it shows the result in **Cell G3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-71.png)<figcaption id="caption-attachment-18154">Example</figcaption>

## Closure:

In the above article, we described the **formulas to sum the values by year using SUMIFS Function in Excel Office 365**. Don’t forget to share your worthwhile **feedback** in the below comment section. Thank you so much for Reading!! Keep learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Sum the values by Month Ignore the year!!](https://geekexcel.com/excel-formulas-to-sum-the-values-by-month-ignore-the-year/)**
- **[Formulas to Create a Summary Count by Month with COUNTIFS Function](https://geekexcel.com/formulas-to-create-summary-count-by-month-with-countifs-function/)**
- [**Excel Formulas to Count Total Matches in Two Ranges!!**](https://geekexcel.com/excel-formulas-to-count-total-matches-in-two-ranges/)