SUMIFS between two dates (Excel)

SUMIFS between two dates, with multiple criteria or different types of criteria: learn how to use Excel conditional sum like a pro! If you don’t know what’s the difference between SUMIF and SUMIFS, this article is for you!

Use SUMIFS in Excel instead of VLOOKUP when you need to check multiple criteria before calculating a value.

In this free Excel tutorial, learn what SUMIFS does and how to use it between dates for example.

Did you know you can add up to 126 additional criteria if needed?

SUMIFS will result in a number, the sum of the arguments meeting multiple criteria, within a range.

In MS Excel, SUMIFS is the equivalent of the SUMIF function with multiple criteria.

In Excel,  the SUMIFS formula is =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …). It contains 3 required arguments.

sum_range — the range of cells to sum.
criteria_range1 — the range where the first criteria is checked.
criteria1 — the first criteria checked, defining which cells will be added from criteria_range1.

– Enclose text criteria or criteria with logical/mathematical symbols in quotation marks (“text”).
– You may use wildcard characters in criteria arguments. A question mark (?) will search for any single character and an asterisk (*) will match any sequence of characters.

Use the SUMIFS function to sum data between two dates. Learn how to do it by following these steps:

  • Enter =SUMIFS( in the cell where you want the result of the formula to be displayed
  • Add the range of cells to sum followed by a comma (,)
  • Enter the range where dates appear followed by a comma(,)
  • Enter “>=dd/mm/yyyy“, with dd/mm/yyyy being the oldest date in your time range
  • Again, add the range where dates appear followed by a comma(,)
  • Then, enter “<=dd/mm/yyyy“) with dd/mm/yyyy being this time the most recent date in your time range
  • Finally, click Enter.

In this example, we use SUMIFS between two dates to calculate the invoices total during a specific time range (01/01/2023 to 31/03/2023 included). We highlighted the dates and invoices following our criteria in blue for your convenience.

The formula we use is =SUMIFS(C18:C22,D18:D22,”>=01/01/2023″,D18:D22,”<=31/03/2023″).

C18:C22 corresponds to the range of cells containing invoices values.
D18:D22 corresponds to the range where dates appear.

In this example, we use the SUMIFS function to calculate the invoices total during a specific time range (01/01/2023 to 31/03/2023 included), from our customers based in Europe. We use 3 criteria in our formula.

For clarity, we highlighted the dates and invoices following our different criteria in blue.

The formula we use is =SUMIFS(C18:C22,D18:D22,”>=01/01/2023″,D18:D22,”<=01/04/2023″,B18:B22,”Europe”).

C18:C22 corresponds to the range of cells containing invoices values.
D18:D22 corresponds to the range where dates appear.
B18:B22 is the range of cells where the criteria Europe is applied.

Now, you know what the difference between SUMIF and SUMIFS is in Excel and how to use the latter.

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Advertising News – 09 June 2024

This week, we'll explore Google's latest algorithm update and it's massive impact on independent websites, the newly passed media Freedom Act in the EU aimed at protecting journalists, and a...

Read More

Categories

AllFunctionsToolsShortcut Keys
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Using Text to Column to Extract texts on Excel

Excel: How to split text into columns

If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it's really easy to split text into columns.

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More