Article updated on April 05, 2009

sum-between-a-range-of-dates-for-a-specific-currencyQuestion: 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.
(Excel 97-2003 Workbook *.xls)

Functions in this article:

Adds all the numbers in a range of cells

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