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.
Bookmarks