Spreadsheet: 143994d1330659085-getting-the-sum-of-2nd-column-base-on-the-best-like-value-in-column-1-of-3-worksheets-store-details
Sheet: Nov 2011

Date |  | Memo |  | Debit |  | Credit |  | Salary | expense | cbu | payment | int | overage | passbook | refunded | assets
2011-11-01 00:00:00 |  | pdc 15 |  | 50775
2011-11-02 00:00:00 |  | 468941 |  | 1580.31
2011-11-02 00:00:00 |  | Check no. 468949 |  | 9684.24
2011-11-02 00:00:00 |  | Check no. 468982 |  | 10276.2
2011-11-03 00:00:00 |  | 468953 |  | 4732.48
2011-11-03 00:00:00 |  | Check no.468959 |  | 7187.72
2011-11-03 00:00:00 |  | Check no. 493105 |  | 8484
2011-11-03 00:00:00 |  | cgm |  | 4961.96
2011-11-03 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.05
2011-11-03 00:00:00 |  | interest-Tima-an, [NAME] |  |  |  |  |  |  |  |  |  | 88.05
2011-11-03 00:00:00 |  | int-augusto, aida |  |  |  |  |  |  |  |  |  | 14.3
2011-11-03 00:00:00 |  | [NAME], Erlinda |  |  |  |  |  |  |  |  |  | 70
2011-11-03 00:00:00 |  | sales |  |  |  | 19264.01
2011-11-03 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.14
2011-11-03 00:00:00 |  | int - ledesma, [NAME] |  |  |  |  |  |  |  |  |  | 87
2011-11-04 00:00:00 |  | 493187 |  | 10450
2011-11-04 00:00:00 |  | int-bulanon, [NAME] |  |  |  |  |  |  |  |  |  | 25
2011-11-04 00:00:00 |  | int-azucena, jonalyn |  |  |  |  |  |  |  |  |  | 25
2011-11-04 00:00:00 |  | int-velez, eduvijis |  |  |  |  |  |  |  |  |  | 100
2011-11-04 00:00:00 |  | int-mahusay, editha |  |  |  |  |  |  |  |  |  | 30.5
2011-11-04 00:00:00 |  | cbu-canizares |  |  |  |  |  |  |  | 500
2011-11-04 00:00:00 |  | passbook |  |  |  |  |  |  |  |  |  |  |  | 15
2011-11-04 00:00:00 |  | ovrages |  |  |  |  |  |  |  |  |  |  | 0.73
2011-11-04 00:00:00 |  | [NAME], helen |  |  |  |  |  |  |  |  |  | 50
2011-11-05 00:00:00 |  | Check no. 468984 |  | 6421.1
2011-11-08 00:00:00 |  | 493002 |  | 7150.9
2011-11-08 00:00:00 |  | payment-lumawag, rosela |  |  |  |  |  |  |  |  | 2000
2011-11-08 00:00:00 |  | int-sumadero, celerino |  |  |  |  |  |  |  |  |  | 52
2011-11-08 00:00:00 |  | int-mahilum, jenny |  |  |  |  |  |  |  |  |  | 22
2011-11-08 00:00:00 |  | int-lobaton, arlene |  |  |  |  |  |  |  |  |  | 82.25
2011-11-08 00:00:00 |  | int-tolentino, [NAME] |  |  |  |  |  |  |  |  |  | 754
2011-11-08 00:00:00 |  | int-caballero, perlita |  |  |  |  |  |  |  |  |  | 100
2011-11-08 00:00:00 |  | sales |  |  |  | 19252.01
2011-11-08 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.49
2011-11-08 00:00:00 |  | int-lacson, marlene |  |  |  |  |  |  |  |  |  | 59.7
2011-11-09 00:00:00 |  | Check no. 493108 |  | 2791.2
2011-11-09 00:00:00 |  | Check  no. 493112 |  | 8150.73
2011-11-09 00:00:00 |  | 493195 |  | 47550
2011-11-09 00:00:00 |  | 14 kilos bangus of mam alob @ P110/kilo |  | 1540
2011-11-09 00:00:00 |  | sales |  |  |  | 40708.06
2011-11-09 00:00:00 |  | int-vistar, doreen |  |  |  |  |  |  |  |  |  | 97.4
2011-11-09 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.09
2011-11-10 00:00:00 |  | 493013 |  | 3682.4
2011-11-10 00:00:00 |  | int-bandolon, [NAME] |  |  |  |  |  |  |  |  |  | 24.25
2011-11-10 00:00:00 |  | sales |  |  |  | 8728.8
2011-11-10 00:00:00 |  | overage |  |  |  |  |  |  |  |  |  |  | 0.2
2011-11-11 00:00:00 |  | Check no. 493132 |  | 5710.8
2011-11-11 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.02
2011-11-11 00:00:00 |  | payment egg- [NAME] |  | 1370
2011-11-11 00:00:00 |  | payment sold out products- [NAME] |  | 385
2011-11-11 00:00:00 |  | paper for printer |  |  |  |  |  |  | 125
2011-11-11 00:00:00 |  | int-cartaciano, teresita |  |  |  |  |  |  |  |  |  | 30.5
2011-11-11 00:00:00 |  | int-villalobos, ambros |  |  |  |  |  |  |  |  |  | 57.1
2011-11-11 00:00:00 |  | int-bancolinos, [NAME] |  |  |  |  |  |  |  |  |  | 84.65
2011-11-11 00:00:00 |  | sales |  |  |  | 8476.98
2011-11-12 00:00:00 |  | Philippine General [NAME] |  | 13328.75
2011-11-12 00:00:00 |  | Check no. 493133 |  | 9168.7
2011-11-12 00:00:00 |  | 493026 |  | 9447
2011-11-12 00:00:00 |  | IMC- [NAME] products/cash |  | 23617.94
2011-11-12 00:00:00 |  | int-duerme, marites |  |  |  |  |  |  |  |  |  | 54.75
2011-11-12 00:00:00 |  | int-abong, christina |  |  |  |  |  |  |  |  |  | 100
2011-11-12 00:00:00 |  | int-calopez, susan |  |  |  |  |  |  |  |  |  | 100
2011-11-12 00:00:00 |  | [NAME], Helen 0006-8/10/07 |  |  |  |  |  |  |  |  |  | 50
2011-11-12 00:00:00 |  | sales |  |  |  | 17181.3
2011-11-12 00:00:00 |  | overage |  |  |  |  |  |  |  |  |  |  | 0.2
2011-11-12 00:00:00 |  | int - artajo, evelyn |  |  |  |  |  |  |  |  |  | 59
2011-11-14 00:00:00 |  | payment to dressed chicked- Villalobos |  | 1047.6
2011-11-14 00:00:00 |  | dressed chicken to [NAME] |  | 3326.4
2011-11-14 00:00:00 |  | payment-ESTERA, Eileen jean |  |  |  |  |  |  |  |  | 760
2011-11-14 00:00:00 |  | payment-Nequin, Corazon |  |  |  |  |  |  |  |  | 500
2011-11-14 00:00:00 |  | cbu-artajo, evelyn |  |  |  |  |  |  |  | 100
2011-11-14 00:00:00 |  | passbook |  |  |  |  |  |  |  |  |  |  |  | 15
2011-11-14 00:00:00 |  | int-katalbas, [NAME] fe |  |  |  |  |  |  |  |  |  | 70.25
2011-11-14 00:00:00 |  | int-rodriguez, arlie |  |  |  |  |  |  |  |  |  | 93.5
2011-11-14 00:00:00 |  | int-montano, warlita |  |  |  |  |  |  |  |  |  | 18.5
2011-11-14 00:00:00 |  | cbu-montano, warlita |  |  |  |  |  |  |  | 100
2011-11-14 00:00:00 |  | int-manguilimutan, addie |  |  |  |  |  |  |  |  |  | 36
2011-11-14 00:00:00 |  | int-montano, aileen |  |  |  |  |  |  |  |  |  | 100
2011-11-14 00:00:00 |  | sales |  |  |  | 49147.87
2011-11-14 00:00:00 |  | overages
2011-11-15 00:00:00 |  | Check no. 493046 |  | 8734.72 |  |  |  |  |  |  |  |  | 0.45
2011-11-15 00:00:00 |  | int-lobaton, [NAME] |  |  |  |  |  |  |  |  |  | 23
2011-11-15 00:00:00 |  | int-delos reyes, rosie |  |  |  |  |  |  |  |  |  | 170.3
2011-11-15 00:00:00 |  | int-hazel, andales |  |  |  |  |  |  |  |  |  | 100
2011-11-15 00:00:00 |  | int-padernal, lalie |  |  |  |  |  |  |  |  |  | 63.9
2011-11-15 00:00:00 |  | cbu-padernal, lalie |  |  |  |  |  |  |  |  | 93
2011-11-15 00:00:00 |  | int-diaz, purification |  |  |  |  |  |  |  |  |  | 199.5
2011-11-15 00:00:00 |  | sales |  |  |  | 29057.09
2011-11-15 00:00:00 |  | overage |  |  |  |  |  |  |  |  |  |  | 0.21
2011-11-15 00:00:00 |  | int-elizabeth, perla |  |  |  |  |  |  |  |  |  | 135.33
2011-11-15 00:00:00 |  | int-condevillamar, genesie |  |  |  |  |  |  |  |  |  | 77.27
2011-11-16 00:00:00 |  | plastic/store supplies |  |  |  |  |  |  | 283
2011-11-16 00:00:00 |  | payment to mam [NAME] tray egg |  | 680
2011-11-16 00:00:00 |  | payment to canete, ernie |  | 868
2011-11-16 00:00:00 |  | payment - pardenilla |  |  |  |  |  |  |  |  | 5999.59
2011-11-16 00:00:00 |  | int-pardenilla |  |  |  |  |  |  |  |  |  | 299.78
2011-11-16 00:00:00 |  | payment - peday |  |  |  |  |  |  |  |  | 1000
2011-11-16 00:00:00 |  | [NAME] 10 days @ 223 |  |  |  |  |  | 2230
2011-11-16 00:00:00 |  | int-jaleco, desire |  |  |  |  |  |  |  |  |  | 65.56
2011-11-16 00:00:00 |  | int-bersales, adelfa |  |  |  |  |  |  |  |  |  | 100
2011-11-16 00:00:00 |  | sales |  |  |  | 29074.7
2011-11-16 00:00:00 |  | int-palmos, racel |  |  |  |  |  |  |  |  |  | 54.85
2011-11-16 00:00:00 |  | int-escribano, edelyn |  |  |  |  |  |  |  |  |  | 93
2011-11-17 00:00:00 |  | 493032 |  | 4695.24
2011-11-17 00:00:00 |  | Ajinomoto Philippines Corporation |  | 10449.1
2011-11-17 00:00:00 |  | payment for egg-Teodoso, jorie |  | 1370
2011-11-17 00:00:00 |  | payment to consumer store |  |  |  |  |  |  |  |  | 12001.5
2011-11-17 00:00:00 |  | payment - alonsabe |  |  |  |  |  |  |  |  | 500
2011-11-17 00:00:00 |  | cbu-alonsabe |  |  |  |  |  |  |  | 100
2011-11-17 00:00:00 |  | sales |  |  |  | 21346.85
2011-11-17 00:00:00 |  | overage |  |  |  |  |  |  |  |  |  |  | 0.3
2011-11-17 00:00:00 |  | int-elare, baby rose |  |  |  |  |  |  |  |  |  | 39.75
2011-11-18 00:00:00 |  | 493176 |  | 29361.65
2011-11-18 00:00:00 |  | 493196 |  | 52255
2011-11-18 00:00:00 |  | Negros Longlife Corporation |  | 4320
2011-11-18 00:00:00 |  | IMC |  | 34356
2011-11-18 00:00:00 |  | withdrawal of cbu-lacson, [NAME] lyn |  |  |  |  |  |  |  |  |  |  |  |  | 1000
2011-11-18 00:00:00 |  | baboy-penas, delfin |  | 5102
2011-11-18 00:00:00 |  | cbu-Nidar, Rizaldy |  |  |  |  |  |  |  | 500
2011-11-18 00:00:00 |  | remittnce nnscst Sept. |  |  |  |  |  |  |  |  | 32584.91
2011-11-18 00:00:00 |  | int |  |  |  |  |  |  |  |  |  | 2505.14
2011-11-18 00:00:00 |  | [NAME], corazon |  |  |  |  |  |  |  |  | 500
2011-11-18 00:00:00 |  | int-katalbas, lorna |  |  |  |  |  |  |  |  |  | 112
2011-11-18 00:00:00 |  | int - Ugaban, Maja Bernabat |  |  |  |  |  |  |  |  |  | 192
2011-11-18 00:00:00 |  | [NAME], willy |  |  |  |  |  |  |  |  |  | 181
2011-11-18 00:00:00 |  | int - Logatiman, [NAME] |  |  |  |  |  |  |  |  |  | 36.44
2011-11-18 00:00:00 |  | int-lacson, [NAME]. Lyn |  |  |  |  |  |  |  |  |  | 150
2011-11-18 00:00:00 |  | passbook |  |  |  |  |  |  |  |  |  |  |  | 15
2011-11-18 00:00:00 |  | cbu-camorista, lorette |  |  |  |  |  |  |  | 500
2011-11-18 00:00:00 |  | int-abetria, nancy |  |  |  |  |  |  |  |  |  | 255.22
2011-11-18 00:00:00 |  | int-Sallutan, Merlyn |  |  |  |  |  |  |  |  |  | 33.15
2011-11-18 00:00:00 |  | cbu-zabala, [NAME] |  |  |  |  |  |  |  | 1000
2011-11-18 00:00:00 |  | passbook |  |  |  |  |  |  |  |  |  |  |  | 15
2011-11-18 00:00:00 |  | sales |  |  |  | 29756.29
2011-11-18 00:00:00 |  | overage |  |  |  |  |  |  |  |  |  |  | 0.15
2011-11-18 00:00:00 |  | int-ibanes, llane |  |  |  |  |  |  |  |  |  | 68.67
2011-11-19 00:00:00 |  | Virginia |  | 5376.53
2011-11-19 00:00:00 |  | int-cabahug, merlyn |  |  |  |  |  |  |  |  |  | 46.25
2011-11-19 00:00:00 |  | int-taganile, evelyn |  |  |  |  |  |  |  |  |  | 82.5
2011-11-19 00:00:00 |  | int - daanoy, vhan |  |  |  |  |  |  |  |  |  | 19.3
2011-11-19 00:00:00 |  | sales |  |  |  | 24055.38
2011-11-19 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.2
2011-11-21 00:00:00 |  | 493014 |  | 5701.8
2011-11-21 00:00:00 |  | payment-encanto, [NAME] |  |  |  |  |  |  |  |  | 1500
2011-11-21 00:00:00 |  | int-valiente, joy |  |  |  |  |  |  |  |  |  | 55
2011-11-21 00:00:00 |  | int-aurelio, fe |  |  |  |  |  |  |  |  |  | 100
2011-11-21 00:00:00 |  | int-delos reyes, evelyn |  |  |  |  |  |  |  |  |  | 48.5
2011-11-21 00:00:00 |  | int-mahilum, jenny |  |  |  |  |  |  |  |  |  | 31.5
2011-11-21 00:00:00 |  | sales |  |  |  | 22392.46
2011-11-21 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.54
2011-11-21 00:00:00 |  | int-batayen, evelyn |  |  |  |  |  |  |  |  |  | 54.75
2011-11-21 00:00:00 |  | int-troberos, maricel |  |  |  |  |  |  |  |  |  | 72
2011-11-21 00:00:00 |  | sales |  |  |  | 17857.26
2011-11-21 00:00:00 |  | int-dolorico, [NAME] |  |  |  |  |  |  |  |  |  | 64.82
2011-11-22 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.17
2011-11-22 00:00:00 |  | int-mermida, rose |  |  |  |  |  |  |  |  |  | 149.25
2011-11-23 00:00:00 |  | 493194 |  | 5686.02
2011-11-23 00:00:00 |  | [NAME]'s |  | 12300
2011-11-23 00:00:00 |  | cbu-mermida, rose |  |  |  |  |  |  |  | 200
2011-11-23 00:00:00 |  | int-ugaban |  |  |  |  |  |  |  |  |  | 86
2011-11-23 00:00:00 |  | int-agbones, vilma |  |  |  |  |  |  |  |  |  | 92.12
2011-11-23 00:00:00 |  | int-doromal, nancy |  |  |  |  |  |  |  |  |  | 49.78
2011-11-23 00:00:00 |  | int-miralles, rose aida |  |  |  |  |  |  |  |  |  | 311.55
2011-11-23 00:00:00 |  | int-miralles, rose aida |  |  |  |  |  |  |  |  |  | 136
2011-11-23 00:00:00 |  | int-bulanon, [NAME] |  |  |  |  |  |  |  |  |  | 25
2011-11-23 00:00:00 |  | sales |  |  |  | 18858.93
2011-11-23 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.43
2011-11-23 00:00:00 |  | int-augusto, aida |  |  |  |  |  |  |  |  |  | 68
2011-11-23 00:00:00 |  | int-lobaton, mila |  |  |  |  |  |  |  |  |  | 98.7
2011-11-23 00:00:00 |  | int-condevillamar |  |  |  |  |  |  |  |  |  | 49
2011-11-23 00:00:00 |  | int - Padernal, Lalie |  |  |  |  |  |  |  |  |  | 75
2011-11-24 00:00:00 |  | Nuyad, [NAME] |  | 54925.74
2011-11-24 00:00:00 |  | Check no. 492806 |  | 6365.7
2011-11-24 00:00:00 |  | sales |  |  |  | 17564
2011-11-25 00:00:00 |  | 493017 |  | 1198.62
2011-11-25 00:00:00 |  | 493019 |  | 5554.8
2011-11-25 00:00:00 |  | IONASIA, INC. |  | 3829
2011-11-25 00:00:00 |  | SYL |  | 7633.92
2011-11-25 00:00:00 |  | payment andrada items |  | 4472.8
2011-11-25 00:00:00 |  | int-ignacio, jesusa |  |  |  |  |  |  |  |  |  | 110.28
2011-11-25 00:00:00 |  | int-bolivar, rosemarie |  |  |  |  |  |  |  |  |  | 69.5
2011-11-25 00:00:00 |  | int-gonzales, grace |  |  |  |  |  |  |  |  |  | 52.97
2011-11-25 00:00:00 |  | sales |  |  |  | 24186.47
2011-11-25 00:00:00 |  | overage |  |  |  |  |  |  |  |  |  |  | 1.28
2011-11-25 00:00:00 |  | int-cajocson, [NAME] |  |  |  |  |  |  |  |  |  | 60.95
2011-11-26 00:00:00 |  | 493023 |  | 5832.24
2011-11-26 00:00:00 |  | Gold Harvest Mktg. |  | 2055
2011-11-26 00:00:00 |  | CYM Marketing |  | 2949
2011-11-26 00:00:00 |  | IMC |  | 14581.41
2011-11-26 00:00:00 |  | CONSUMER SUPPLIES |  |  |  |  |  |  | 299
2011-11-26 00:00:00 |  | SOLD ITEMS FOR MAM PATANI |  | 49
2011-11-26 00:00:00 |  | sales |  |  |  | 16089.55
2011-11-26 00:00:00 |  | overages |  |  |  |  |  |  |  |  |  |  | 0.5
2011-11-26 00:00:00 |  | [NAME], helen |  |  |  |  |  |  |  |  |  | 50
2011-11-28 00:00:00 |  | payment-Patani, [NAME] |  | 264
2011-11-28 00:00:00 |  | int-cena, may |  |  |  |  |  |  |  |  |  | 75
2011-11-28 00:00:00 |  | int-katalbas, lorna |  |  |  |  |  |  |  |  |  | 38.75
2011-11-28 00:00:00 |  | sales |  |  |  | 10669.4
2011-11-29 00:00:00 |  | Check no. 492995 |  | 7410.63
2011-11-29 00:00:00 |  | Check no.492861 |  | 3685.1
2011-11-29 00:00:00 |  | check no. 492874 |  | 15467.35
2011-11-29 00:00:00 |  | payment-peday |  |  |  |  |  |  |  |  | 1000
2011-11-29 00:00:00 |  | int-peday |  |  |  |  |  |  |  |  |  | 275
2011-11-29 00:00:00 |  | payment-basanta |  |  |  |  |  |  |  |  | 250
2011-11-29 00:00:00 |  | int-basanta |  |  |  |  |  |  |  |  |  | 38
2011-11-29 00:00:00 |  | [NAME] 12 days @ 223 |  |  |  |  |  | 2676
2011-11-29 00:00:00 |  | payment-gotib, jester |  |  |  |  |  |  |  |  | 1000
2011-11-29 00:00:00 |  | int-gotib, jester |  |  |  |  |  |  |  |  |  | 340
2011-11-29 00:00:00 |  | payment-katalbas, bessie |  |  |  |  |  |  |  |  | 60
2011-11-29 00:00:00 |  | payment-Katalbas, Bessie |  |  |  |  |  |  |  |  | 817
2011-11-29 00:00:00 |  | int-deslate |  |  |  |  |  |  |  |  |  | 48
2011-11-29 00:00:00 |  | cbu-abello, juanito |  |  |  |  |  |  |  |  | 1000
2011-11-29 00:00:00 |  | passbook |  |  |  |  |  |  |  |  |  |  |  | 15
2011-11-29 00:00:00 |  | int-villalobos |  |  |  |  |  |  |  |  |  | 55.45
2011-11-29 00:00:00 |  | int-aspera, [NAME] |  |  |  |  |  |  |  |  |  | 69.75
2011-11-29 00:00:00 |  | int-solasco, judith |  |  |  |  |  |  |  |  |  | 162.9
2011-11-29 00:00:00 |  | sales |  |  |  | 22090.34
2011-11-30 00:00:00 |  | Jarlop Distributions Inc. |  | 2151.52