Hi
One way, assuming your dates to be in column A and your amounts in column B
=SUMPRODUCT(--($A$1:$A$100=DATE(2005,10,1)),--($A$1:$A$100<=DATE(2005,10,31),B1:B100)
Change ranges to suit, but do ensure they are all of equal size.
Regards
Roger Govier
ruleb wrote:
How can I sum a range of amounts, each of which has a respective date
associated with it, based on whether or not that date is less than or equal
to a cutoff date (i.e, add together all the amounts that occured between
10/1/05 and 10/31/05?
|