Data for todays date and before

Hi all

I have dates from 01/03/08 to 31/03/08 in Column Z and next to this in column AA i have ammounts of money, i want to have a formula that will calculate all the ammounts from the 01/03/08 to the current date, so basicly looking for anything that is due today or has expired, can this be done?

Thanks in advance

DJ

Check out SUMPRODUCT

http://xldynamic.com/source/xld.SUMPRODUCT.html

Ed