## Sum between two dates

*Article 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

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 […]### Leave a Reply

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

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

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

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

VBA code

[/vb]

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

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

## Share this article