## Determine the sum between a range of dates for a specific currency

*Article updated on April 05, 2009*

**Question:** I am trying to determine the sum between two dates where currency = AUD. How?

**Answer: **To the right is a picture of some random dates, amounts and currencys**.**

The picture below shows an example start and end date. Yellow cells are user input cells**.**

USD and AUS amounts within the date range are summed.

Here is the formula i USD cell: =SUM(($A$2:$A$10<$F$8)*($A$2:$A$10>$F$7)*($B$2:$B$10=$E10)*($C$2:$C$10)) + Ctrl + Shift + Enter

Here is the formula i AUS cell: =SUM(($A$2:$A$10<$F$8)*($A$2:$A$10>$F$7)*($B$2:$B$10=$E11)*($C$2:$C$10)) + Ctrl + Shift + Enter

To sort the currencys into months, see picture below.

Formula in F2: =SUM((MONTH($A$2:$A$10)=1)*(YEAR($A$2:$A$10)=2008)*($B$2:$B$10=F$1)*$C$2:$C$10) + Ctrl + Shift + Enter

Download excel sample file for this article.

currency.xls

(Excel 97-2003 Workbook *.xls)

**Functions in this article:**

**SUM(**number1,[number2],**)
**Adds all the numbers in a range of cells

**MONTH(**serial_number**)** returns the month, a number from 1 (January) to 12 (December)

Lookup and return multiple values concatenated into one cell

This article demonstrates how to find a value in a column and concatenate corresponding values on the same row. The […]### 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