SUMPRODUCT Function Compare Date

[Raj]

I have two sheets in a workbook that have the following columns
Sheet1
Col1 Col2
01/01/2008
01/03/2008
02/09/2008

Sheet2
Col1 Col2 Col3
01/01/2008 23
01/01/2008 45
01/01/2008 123
01/03/2008 232
02/09/2008 11

Now I need to populate the value of Col2 in Sheet1 with the sum of values in
Col2 where Sheet2!Col1 is same as Sheet1!Col1

I am trying to use SUMPRODUCT function, however, the comparison of dates
doesnt work as expected(I guess the value is being compared instead of the
date). I cant use the DATE function as I cannot hardcode a particular date.

=SUMPRODUCT((SHEET2!A1:A14=A1)*(SHEET2!B1:B14))

Thanks in Advance.

 

[Teethless mama]

=SUMIF(Sheet2!A:A,A1,Sheet2!B:B)

 

[Raj]

Geez, that was simple. Thanks Teethless mama.

=SUMIF(Sheet2!A:A,A1,Sheet2!B:B)

 

[Teethless mama]

You're Welcome!

Geez, that was simple. Thanks Teethless mama.