Match Date (Column A) and add all value (Column D) for that date, return one value

I have an FX Banking Worksheet, that I would like to add a match formula. Need to look at Column B (Due Date) and then go to Column (H) NZD Amount to Pay, add up all amounts due for say the 15/04/2013 and return one value to pay in formula column.

Thank you
Britte

Originally Posted by bebo021999

Have you tried SUMIF?
=SUMIF(B:B,I1,H:H)
With I1 to say given date.

Hi, Yes but then it only returns value in column H example 17/03/2013, will return $2,807.38. I want it to find all the values matching 17/03/2013 from A1:H137 and return 1xvalue for 17/03/2013. Then next date and next date. So banking can be calculated and added to cashflow for payment on this due date. Britte

Happy that it is now working, had 1 x column going wrong when dragging formula. Picked up error when double checking and now added $$ to keep formula in tact. Thank you for your help. This was great.