Extracting data based on dates

Hi guys,

I have a table with 'Product Rereference', 'Date', and 'Estimated Assets' Columns. I need to run a formula that will extract the number in my 'Estimated Assets' column, based on speicific list of 'Product Reference' numbers that I have filetered, and a specific date - 1/31/ of each year.

I've been trying to create a formula, however I can't seem to work it out.

I have attached a file, which should make things a lot clearer :P I am trying to make the data extract into the table to the right. I have filled in the first few columns manually, to show what I would like to formula to achieve.

Would be very grateful for any help I can get!

Jodapo

Put this formula in H3, then copy down and across. Be sure to widen those columns!

=SUMPRODUCT(--(YEAR($B$3:$B$6000)=H$2),--($A$3:$A$6000=$G3),$E$3:$E$6000)

Like so:

=SUMPRODUCT(--(YEAR($B$3:$B$6000)=H$2),--(MONTH($B$3:$B$6000)=1),--($A$3:$A$6000=$G3),$E$3:$E$6000)