MATCHING multiple values and SUMMING

We have a table that records payment dates and amounts ... and it categorizes how the payment was made. See attached file to help understand the process.


Column A records the payment date. Two or more payments can be recorded for the same date!!!

Column B records the amount of payment.

Column C records the method of payment (OL or LB or CC or CK).


Here's what we need:

On a given date (cell J4), we need to match any dates in Col A ... and we need to SUM all payments that match that date .... and the SUM needs to be based upon the method of payment (OL or LB ...) and values stored respectively in E4,F4,G4,H4 (or left blank if no date match).


Any help would be appreciated (formula-based solutions please!!). Thank you very much!!

Thank you both for your solutions!! Both work equally well, but we may go with your solution Martin since you mentioned it may work better with Excel 2010.

Really appreciate your help gentlemen!! Thank you very much!!