Problem: I have a list of records say with an amount and a date. How can I analyses the list based on the date range i.e. all records between say
date 1 and date 2 total x. I would like the total to be returned to a
single cell
Solution: Assuming the value is in A1:A100 and the dates are in B1:B100
=SUMPRODUCT((B1:B100>=DATEVALUE("1/1/2013"))*(B1:B100<=DATEVALUE("31/1/2013")),A1:A100)
will return the sum of the values fro January 2013
