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

General Formula:

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

=SUMIFS(sum_range,date,”>=”&DATE(year),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.
• YEAR – The Excel YEAR function 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

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!! *and Excel Formulas *!!

Related Articles:

• Excel Formulas to Sum the values by Month Ignore the year!!
• Formulas to Create a Summary Count by Month with COUNTIFS Function
• Excel Formulas to Count Total Matches in Two Ranges!!