## Sum between two dates

*Article last updated on March 25, 2018*

The formula in cell C15 uses two dates two to filter and then sum values in column C, the SUMIFS function is designed to use multiple conditions.

The first condition filters dates less than or equal to the end date in cell C14.

"<="&C14

The second condition filters dates larger than or equal to the start date in cell C13.

">="&C13

The ampersand character lets you concatenate the logical operators to the date value. The following picture shows the date values that match both conditions.

The SUMIFS function has the following arguments:

*sum_range*,

*criteria_range1*,

*criteria1*, [

*criteria_range2*,

*criteria2*], ...)

### Sum by date range

The SUMIFS was introduced in Excel 2007, the following formula works with Excel versions earlier than 2007.

### Download excel *.xlsx

Use MEDIAN function to calculate overlapping ranges

I found an old post that I think is interesting to write about today. Think of two overlapping ranges, it may be dates, […]

The NETWORKDAYS function allows you to count weekdays or workdays between two dates. It ignores weekends and a custom date list […]

The DATEDIF function in cell E3 allows you to calculate days between two dates. Related articles Use MEDIAN function to […]

To extract groups from cell range B3:B10 I use the following regular formula in cell B13. Related articles Running totals The […]

The SUM function in cell D3 uses only a single cell reference and still manages to sum current and previous […]

Sum values between two dates and based on a condition

In this post, I will provide a formula to sum values in column (Qty) where a column (Date) meets two […]

This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]

Count how many times a string exists in a cell range (case insensitive)

Question: How do I count how many times a word exists in a range of cells? It does not have […]

Sum values between two dates and based on a condition

In this post, I will provide a formula to sum values in column (Qty) where a column (Date) meets two […]

Katie asks: I have 57 sheets many of which are linked together by formulas, I need to get numbers from […]

### Leave a Reply

### How to comment

**How to add a formula to your comment**

<code>Insert your formula here.</code>

**Convert less than and larger than signs**

Use html character entities instead of less than and larger than signs.

< becomes < and > becomes >

**How to add VBA code to your comment**

[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org or imgur

Use the img tag, like this: <img src="Insert pic link here">

**Contact Oscar**

You can contact me through this contact form