## Sum numbers between two dates

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

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 […]

Running totals based on criteria

Andrew asks: LOVE this example, my issue/need is, I need to add the results. So instead of States and Names, […]

The formula in cell D3 adds all unique numbers in cell range B3:B12Â and returns the total. Unique values are all […]

Find empty cells and sum cells above

Is itÂ possible to quickly select all empty cells and then sum cells above to next empty cell? Can I have […]

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

Question: It's easy to sum a list by multiple criteria, you just use array formula a la: =SUM((column_plane=TRUE)*(column_countries="USA")*(column_producer="Boeing")*(column_to_sum)) But all […]

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 […]

The SUBTOTAL function lets you sum values in a cell range that have some rows hidden or filtered, the picture […]

### 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

Paste image link to your comment.

**Contact Oscar**

You can contact me through this contact form