[Excel 2010] Daily summary from date+time values

Hello Everyone,



I have a sheet1 with date+time and values:

2010/07/12 04:39:50 ; 100
2010/07/12 14:52:10 ; -10
2010/07/13 01:56:34 ; 100
2010/07/13 12:41:02 ; 50
etc.

On another sheet2, I am attempting to make a "daily summary" using a SUMIF

2010/07/12 ; =SUMIF((sheet1!A:A),A1,sheet1!B:B) //result should be 90
2010/07/13 ; =SUMIF((sheet1!A:A),A2,sheet1!B:B) //result should be 150
etc.

The issue is, sheet1 features date+time and sheet2 only the date (it seemsthe time value is 00:00:00 by default), and the SUMIF() returns 0.

I have tried many workarounds, but none worked. Do you have any idea on how to make this work?

Many thanks,

What would be more useful would be a workbook with dummy data in.

I think the most efficient way would be a PivotTable, with the dates Grouped by Days

I think the Pivottable would be better than Sumifs. Here's an example for 2007.

Note: the data is set as Table, now as you add data to the table you can open the Summary sheet and select a cell in the PivotTable and click Refresh in the Data group on the Options tab of the ribbon.