Dear All,

I'm a new user on excel and facing a problem which I cannot seem to find an answer to. I have a workbook with two sheets, on the first sheet I have a list of numbers in one column and a list of dates in the next column. In the second sheet I want to sum the cells which meet a specified date range which I input. For example, if I put on sheet2 start_date 01-01-2012 and end_date 30-01-2012 it should sum the cells from sheet1 within this range. How do I do this? please help, my boss is asking me to do this.