Spreadsheet: 221316d1363466307-sumif-with-conditional-formatting-sum-conditional-formatting
Sheet: Sheet2

Br Code | LAN No | Receipt No | Receipt Date | EMI | Collected EMI | [NAME] | Penal Amount | Foreclosure Amount | Collected BKT | Product Type
150 | 15025400000500 | 6623092 | 2013-03-01 00:00:00 | 4810 | 4810 | 100 |  |  | 1 | [NAME]
150 | 15025300000230 | 6623091 | 2013-03-01 00:00:00 | 3006 | 3006 | 10 |  |  | 1 | [NAME]
150 | 15010400000100 | 6623094 | 2013-03-02 00:00:00 | 9513 | 9513 | 20 |  |  | 1 | Mortgage
150 | 15010400000140 | 6623093 | 2013-03-01 00:00:00 | 13333 | 13333 | 215 |  |  | 1 | Mortgage
150 | 15025400000110 | 6623096 | 2013-03-02 00:00:00 | 5108 | 5108 | 0 |  |  | 1 | [NAME]
150 | 15025400000110 | 6623095 | 2013-03-02 00:00:00 | 12088 | 5108 | 40 |  |  | 2.366483946750196 | [NAME]
150 | 15015800000610 | 6738253 | 2013-03-04 00:00:00 | 5198 | 5198 | 1 |  |  | 1 | PL Self
150 | 15015800000260 | 6738252 | 2013-03-04 00:00:00 | 7869 | 7869 | 15 |  |  | 1 | PL Self
150 | 15025400000710 | 6738208 | 2013-03-04 00:00:00 | 5620 | 2810 |  |  |  | 2 | [NAME]
150 | 15015000004480 | 6738207 | 2013-03-04 00:00:00 | 3728 | 3728 |  |  |  | 1 | PL Self
150 | 15015200003130 | 6738209 | 2013-03-05 00:00:00 | 7578 | 7578 |  |  |  | 1 | PL Self
150 | 15015800000440 | 6738210 | 2013-03-05 00:00:00 | 10601 | 10601 |  |  |  | 1 | PL Self
150 | 15025400000080 | 6738226 | 2013-03-05 00:00:00 | 2379 | 2379 |  |  |  | 1 | [NAME]
150 | 15025400000170 | 6738254 | 2013-03-04 00:00:00 | 4884 | 4884 |  |  |  | 1 | [NAME]
150 | 15015800000470 | 6738255 | 2013-03-06 00:00:00 | 13538 | 13538 |  |  |  | 1 | PL Self
150 | 15025400000720 | 6738227 | 2013-03-06 00:00:00 | 4795 | 4795 |  |  |  | 1 | [NAME]
150 | 15025400000640 | 6738228 | 2013-03-06 00:00:00 | 4805 | 4805 |  |  |  | 1 | [NAME]
150 | 15025400000440 | 6738229 | 2013-03-06 00:00:00 | 3249 | 3249 |  |  |  | 1 | [NAME]
150 | 15015800000190 | Cheque Deposited | 2013-03-04 00:00:00 | 25100 | 25100 |  |  |  | 1 | PL Self
150 | 15025400000220 | Cheque Deposited | 2013-03-04 00:00:00 | 4445 | 4445 |  |  |  | 1 | [NAME]
150 | 15015800000370 | Cheque Deposited | 2013-03-04 00:00:00 | 6999 | 6999 |  |  |  | 1 | PL Self
150 | 15025400000230 | Cheque Deposited | 2013-03-04 00:00:00 | 2764 | 2764 |  |  |  | 1 | [NAME]
150 | 15025400000120 | Cheque Deposited | 2013-03-04 00:00:00 | 4246 | 4246 |  |  |  | 1 | [NAME]
150 | 15010400000170 | Cheque Deposited | 2013-03-04 00:00:00 | 14500 | 14500 |  |  |  | 1 | Mortgage
150 | 15015200003090 | Cheque Deposited | 2013-03-04 00:00:00 | 12480 | 12480 |  |  |  | 1 | PL Self
150 | 15015200002360 | Cheque Deposited | 2013-03-04 00:00:00 | 18444 | 18444 |  |  |  | 1 | PL Self
150 | 15025400000060 | Cheque Deposited | 2013-03-04 00:00:00 | 2039 | 2039 |  |  |  | 1 | [NAME]
150 | 15015800000180 | Cheque Deposited | 2013-03-05 00:00:00 | 4731 | 4731 |  |  |  | 1 | PL Self
150 | 15015000004490 | Cheque Deposited | 2013-03-05 00:00:00 | 5503 | 5503 | 0 |  |  | 1 | PL Self
150 | 15015200003170 | Cheque Deposited | 2013-03-05 00:00:00 | 12324 | 12324 | 0 |  |  | 1 | PL Self
150 | 15010400000220 | Cheque Deposited | 2013-03-05 00:00:00 | 25225 | 25225 | 0 |  |  | 1 | Mortgage
150 | 15010400000010 | Cheque Deposited | 2013-03-05 00:00:00 | 13996 | 13996 | 0 |  |  | 1 | Mortgage
150 | 15010400000180 | Cheque Deposited | 2013-03-05 00:00:00 | 15833 | 15833 | 0 |  |  | 1 | Mortgage
150 | 15025400000750 | 6738230 | 2013-03-08 00:00:00 | 4206 | 4206 | 0 |  |  | 1 | [NAME]
150 | 15025400000750 | 6738230 | 2013-03-08 00:00:00 | 4206 | 4206 | 0 |  |  | 1 | [NAME]
150 | 15025400000810 | 6738231 | 2013-03-09 00:00:00 | 4899 | 4899 | 0 |  |  | 1 | [NAME]
150 | 15015800000750 | 6738213 | 2013-03-09 00:00:00 | 22533 | 22533 |  |  |  | 1 | PL Self
150 | 15015800000720 | 6738214 | 2013-03-09 00:00:00 | 23750 | 23750 | 0 |  |  | 1 | PL Self
150 | 15015200003060 | 6738215 | 2013-03-09 00:00:00 | 17779 | 17779 | 0 |  |  | 1 | PL Self
150 | 15015200003150 | 6798212 | 2013-03-09 00:00:00 | 23233 | 23233 | 0 |  |  | 1 | PL Self
150 | 15015800000100 | 6738256 | 2013-03-09 00:00:00 | 17710 | 17710 | 0 |  |  | 1 | PL Self
 |  |  |  |  | - |  |  |  | - | -