Excel 2007 : copy and sum specified cells to another worksheet if date cell is between date range

Hi,

I am quite a newbe so please be patient, thanks.

I currently have a worksheet of data for each different year since 2008. I need to copy specific cells if the date in that row (cell is in same column for each worksheet) falls within the date range I specify to a new worksheet (named totals). Then I will need to sum some of the columns in the TOTALS worksheet.

This may sound childish to some but it is colossal for me.

Thanks

Joe

Hi DILIPandey,

Thanks for the interest shown. I am trying to attach the file now.

The date I want to excel to consider for this operation is the one displayed in column J. If this date falls within a range I specify (say 01/01/2012 to 31/03/2012) I wish that the data in columns O,P,Q, & R is copied to the new worksheet (TOTALS). I will then use autosum for the totals (this bit at least I Know ).

I appreciate your patience.

Joe

If I can manipulate the date range in the formula in the 'Totals' worksheet, I think it will do the trick for me. Unless you can guide me to a simpler solution.
I thank you once more for your kind assistance.

Dear DiliPandy,

You are a wizard mate. I am still trying to work out how you did that. If you don't mind I will come back in a couple of days' time to enquire what the end of the formula means. But for now I will try to implement it in my worksheets.

I really appreciate.

Regards,

Joe

Good morning Dilipandy,

It's me again. I am trying to change the date column reference from sheet 1, from C to column J. when I do this the result is Value!!
this is my amended formula in Totals C2: =SUM(IF((Sheet1!$J$2:$J$66>=TOTALS!$A$1)*(Sheet1!$J$2:$J$66<=TOTALS!$B$1),Sheet1!O$2:O$66,""))
what am I doing wrong??
Please bear with me.

Joe