In Ms Excel Work book, I need to match an amount of more than one presented cheqs , which are cleared today, I want to lookup the exact total of these presented cheqs which is difference from my last day closing bank account balance and current bank balance.
Last day bank balance was Rs.50,000
last day not presented cheqs
1. chq#123456 dated:20-08-16........... Rs.4,001
2. chq#123457 dated:21-08-16........... Rs.5,385
3. chq#123458 dated:25-08-16........... Rs.4,350
Today's bank balance was Rs.59,386.
Difference.....Rs. 9,386. (i need this diff amount automatically mentioned the two cheqs (Sr#.1&2)
Hop you understand my low English :) and solve my problem.