Spreadsheet: 215348d1361355006-creating-list-based-on-several-criteria-on-another-sheet-sal1check
Sheet: Sheet3

Sum of TOTAL HNA |  |  | year | month
 |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 | Grand Total
PS BY JAN 2013 | O_code | O_Name | Jan | Feb | Mar | Apr | [NAME] | Jun | Jul | Agust | Sep | Okt | Nop | Des | Jan
DENI JULIANA SARAGI |  |  | 15996000 | 6751500 | 12277000 | 7400000 | 34658500 | 936000 | 16128000 | 10242000 | 15834000 | 8317000 | 6552500 | 3134000 | 5028000 | 143254500
HARLEN |  |  | 18735000 | 20645000 | 27900000 | 16340000 | 18930000 | 34685000 | 30170000 | 50580000 | 93110000 | 17720000 | 15820000 | 87880000 | 94870000 | 527385000
MANSON PP | 1600075 | KARYA UTAMA SEHAT SEJAHTERA, PT/ RS |  |  |  |  |  |  |  |  |  |  | 9900000 |  | 7920000 | 17820000
 | 1600174 | RS. HAJI-MEDAN, RS | 10400000 | 2600000 |  |  |  |  |  |  |  | 16048000 |  |  |  | 29048000
 | 1600624 | SAUDARA JAYA(SIDIKALANG), AP. |  |  |  |  |  |  |  |  |  |  | 3240000 |  |  | 3240000
 | 1601314 | HARAPAN IBU(MEDAN), RS |  | 1080000 | 2160000 |  |  | 4023000 | 4320000 |  |  |  |  |  |  | 11583000
 | 1601415 | MATERNA(MEDAN), RS |  |  | 162000 |  |  |  |  |  | 162000 |  |  | 270000 |  | 594000
 | 1603196 | CUT MEUTIA INSTALASI FARMASI(LANGSA |  | 1080000 | 1080000 |  |  |  |  |  |  |  | 1905000 |  |  | 4065000
 | 1604151 | ADVENT (MEDAN), RS |  |  |  |  | 495000 | 495000 | 1112000 |  | 1980000 | 1485000 | 990000 | 990000 | 495000 | 8042000
 | 1604743 | DR PIRNGADI (MEDAN), RS |  |  |  |  |  |  |  |  |  |  | 19800000 |  | 14850000 | 34650000
 | 1604754 | HERNA ( MEDAN ), RS |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0
 | 1604908 | KARYA PRIMATAMA (MEDAN), [NAME] |  |  |  |  |  |  |  |  | 2550000 |  |  |  |  | 2550000
 | 1606853 | CV. TIRTA MEDICALINDO ( MEDAN ), PB | 313500 |  |  |  |  |  |  |  |  |  |  |  |  | 313500
 | 1606899 | KLINIK SPESIALIS STEPHANIE (MEDAN) |  |  |  |  |  |  |  |  |  |  | 2160000 |  |  | 2160000
 | 1607316 | CV. TALA ( MEDAN ) |  |  |  |  |  |  |  | 610000 |  | 1144000 | 2488000 | 2120000 | -520000 | 5842000
 | 1607491 | SUMBER JAYA BARU ( MEDAN ), [NAME] |  | 80000 |  |  |  |  |  |  |  |  |  |  |  | 80000
 | 1607708 | ANUGRAH SATOLOP MAHITTA ( MEDAN ), | 15120000 | 362500 |  | 189000 | 8451000 |  | 5400000 | 12960000 |  | 2160000 | 135000 |  | 135000 | 44912500
 | 1607740 | RSKB ACCUPLAST ( MEDAN ) |  |  | 122000 | 122000 | 122000 |  |  |  | 176000 |  |  |  | 176000 | 718000
 | 1607764 | PT. PERMATA AYAH BUNDA ( MEDAN ) |  |  |  |  |  |  |  | 2550000 | -2550000 |  |  |  |  | 0
 | 1607811 | DR. [NAME] ( KLINIK M 77 ) MEDAN |  |  |  |  |  |  |  |  |  |  | 990000 | 0 |  | 990000
 | 1607863 | KARYA MAMA ( BINJAI ), AP |  |  | 183000 |  |  |  |  |  |  |  |  |  |  | 183000
 | 1608030 | ASNIDA BUMI PERSADA ( MEDAN ), [NAME] |  |  |  | 3000000 | 6200000 | 16300000 |  | 5950000 |  | 6200000 |  |  | 3000000 | 40650000
 | 1608204 | MITRA SUKSES SEJATI  (MEDAN) CV |  |  |  | 2160000 |  | 1080000 |  |  | 2310000 |  |  |  |  | 5550000
 | 1608209 | KARYA MEDIKA UTAMA ( DELITUA ), [NAME] |  | 0 | 4555000 | 7100000 | 7710000 | 1300000 | 5400000 | 5400000 | 6480000 |  |  |  |  | 37945000
 | 1608677 | PT.KARYA [NAME] SEJAHTERA |  |  |  |  |  |  |  |  |  |  | 5445000 | 6930000 | 990000 | 13365000
 | 1609059 | ATHIQA (MEDAN) CV |  |  | 2225000 |  | 310000 | 2075000 |  |  |  |  |  |  |  | 4610000
 | 1609504 | WIRA MITRA PHARMALAB (MEDAN) PT |  |  |  |  |  |  |  |  |  | 1130000 |  |  | 0 | 1130000
 | 1609564 | CV.JOVI KARUNIA JAYA (MEDAN) |  |  |  |  |  |  |  | 2688000 | 1920000 | 3840000 | 6480000 | 5160000 | 4080000 | 24168000
 | 1609790 | KLINIK DR [NAME] (MEDAN) |  |  |  |  |  |  |  |  |  | 438000 |  |  |  | 438000
MANSON PP Total |  |  | 25833500 | 5202500 | 10487000 | 12571000 | 23288000 | 25273000 | 16232000 | 30158000 | 13028000 | 32445000 | 53533000 | 15470000 | 31126000 | 294647000
NELSY |  |  |  |  |  |  |  |  |  | 5814000 | 25299000 | 13116000 | 34235000 | 36114000 | 44043000 | 158621000
PUSPA SARI |  |  | 33624000 | 6262000 | 81564000 | 90735000 | 45396000 | 5184000 | 15732000 | 95184000 | 78004000 | 72475000 | 77834000 | 105606000 | 125189000 | 832789000
Grand Total |  |  | 94188500 | 38861000 | 132228000 | 127046000 | 122272500 | 66078000 | 78262000 | 191978000 | 225275000 | 144073000 | 187974500 | 248204000 | 300256000 | 1956696500