SUMPRODUCT Function Compare Date

  • Thread starter Thread starter Raj
  • Start date Start date
R

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.
 
Back
Top