Extracting particular value from a dates range with perticular date.

I need a formula which can sum the mode of payments seperately occuring on different dates.
Please see the attachme.it is like

table 1
date cash crdit card
1-1-14
2-1-14
3-1-14

table 2
product booking date booking amount payment date payment amount form of payment

a 1-1-14 100 2-1-14 100 credit card
b 1-1-14 150 3-1-14 150 cash
c 2-1-14 200 3-1-14 200 credit card

i want to add value in table 1 from table 2.
In front of date CELL Both cash and credit card amounts should appear seperately.