date
i have data in sheet1. iam working in sheet2. in sheet 1 i used sumif formula
to sum the amount given by the customer.but some time customer gives 2 time
payment. amount is sum in sheet1,but date changes
e.g
customer given 100/- on 12/5/06
same customer given again 200/- on 18/5/06
the amont is calcullated in sheet1. but how i can calc th date
|