SUMPRODUCT Function Compare 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top