AUTO summing DATE WISE

[makinmomb]

This is my data on SHEET1

Reference	Date	Value
INV 182305	03/01/2013	164,755.70
INV 182330	03/01/2013	220,175.00
INV 182722	09/01/2013	208,550.00
INV 182853	10/01/2013	160,240.00
INV 182789	10/01/2013	213,940.00
INV 182917	11/01/2013	271,726.85
INV 182949	11/01/2013	329,837.30

<colgroup><col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <tbody> </tbody>

This is how the result sheet2 looks like , what is the formula on B2 for excel to go fetch totals from the table on sheet1

Date	Value
03/01/2013
04/01/2013
05/01/2013
06/01/2013
07/01/2013
08/01/2013
09/01/2013
10/01/2013
11/01/2013

<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

 

[DILIPandey]

Hi makin,

Try using below formula:-
=SUMPRODUCT((Sheet1!$B$2:$B8=Sheet2!$A2)*(Sheet1!$C$2:$C8))


Regards,
DILIPandey