Spreadsheet: 79330d1279614024-excel-2007-excel-sumif-not-adding-sum-range-correctly-cash-book-march-2010-with-formulas
Sheet: Sheet1

SOLOTRADE- CB | 2010-03-01 00:00:00
SALES | 92 | 20200.8
SALES | 92 | 368741
 | P1 | 13098.6
HP | 55 | 4144.15
HP | 55 | 4144.15
INSURANCE | 18 | 1062.74
MEDICAL AID | 21 | 16805
[NAME] | 14 | 1610.51
[NAME] | 14 | 953.41
[NAME] | 14 | 839.24
NETSTAR SECURITY SERVICE | 20 | 1250 | *
MEDICAL AID | 21 | 324.5
INTERNET | 17 | 290
NETSTAR | 20 | 258
INCORRECT PAYMENT
NETSTAR | 20 | 126.51
BANK CHARGES | 15 | 1011
BANK CHARGES | 15 | 3.32
BANK CHARGES | 15 | 1193.64
SALES | 92 | 536.04
EFT | P1 | 5301
EFT | P1 | 10262.98
EFT | P1 | 7058.88
EFT | P1 | 1729.65
EFT | P1 | 264
SALES | 92 | 234399.79
SALES | 92 | 10431
INSURANCE CLAIM | 102 | 4890.28
INCORRECT PAYMENT REFUND
SALES | 92 | 59000
EFT | P2 | 100300
EFT | P1 | 59097.6
COURIERS | 30 | 8550
EFT | P1 | 5643
EFT | P1 | 3991.62
EFT | P1 | 3610.38
BANK CHARGES | 15 | 312.7
SALES | 92 | 1043.1
SALES | 92 | 151752.24
EFT | P1 | 2120.4
EFT | P1 | 34884
EFT | P1 | 33714.36
EFT | P1 | 8869.77
EFT | P1 | 1805.72
EFT | P1 | 570
INSURANCE | 18 | 12342.29
BANK CHARGES | 15 | 32
SALES | 92 | 153552.37
SALES | 92 | 45577.2
SALES | 92 | 2807.77
IMPORT (CHINA - TLP) | P4 | 6337.4
SALES | 92 | 182909.98
LOAN TO K GOVINDER | 66 | 700000
EFT | P1 | 7097.93
COURIERS | 30 | 6098.14
COMPUTER REPAIRS | 44 | 3900
COURIERS | 30 | 1596
SALES | 92 | 22148.21
SALES | 92 | 9000
SALES | 92 | 4710.34
EFT | P2 | 40000
EFT | P1 | 3283.2
EFT | P1 | 1020.87
VEHICLE MAINTENANCE | 5 | 919.51
FUEL | 23 | 430.31
SALES | 92 | 3260.64
SALES | 92 | 39672
BANK CHARGES | 15 | 27
EFT | P1 | 3703.86
VEHICLE MAINTENANCE | 5 | 1075
INTERNET BAND WIDTH | 26 | 478.8
VEHICLE MAINTENANCE | 5 | 425
SALES | 92 | 57834.66
EFT | P1 | 13320.9
EFT | P1 | 10214.4
EFT | P1 | 2553.6
EFT | P1 | 2013.97
EFT | P1 | 1304.16
SALES | 92 | 155906.69
[NAME] | 14 | 3175
[NAME] | 14 | 1230
[NAME] | 14 | 972
[NAME] (KOREA-HANJIN) | P5 | 125544
[NAME] (CHINA-TANGS) | P6 | 35481
EFT | P1 | 4240.8
EFT | P2 | 12600
EFT | P1 | 6320.16
EFT | P1 | 5650
EFT | P1 | 513
EFT | P1 | 7421.4
EFT | P1 | 63048
EFT | P1 | 22230
EFT | P1 | 1259.71
VEHICLE MAINTENANCE | 5 | 822
EFT | P1 | 13265.15
EFT | P1 | 7574.87
EFT | P1 | 3822
EFT | P1 | 1088.93
COMPUTER REPAIRS | 44 | 900.6
BANK CHARGES | 15 | 27
SALES | 92 | 18900
SALES | 92 | 23523.03
EFT | P2 | 14700
EFT | P1 | 9004.18
EFT | P1 | 2530.8
EFT | P1 | 748.64
INTERNET BAND WIDTH | 26 | 478.8
VEHICLE MAINTENANCE | 5 | 456
INTERNET BAND WIDTH | 26 | 29
BANK CHARGE - REFUND | 103 | 529.08
SALES | 92 | 45032.65
SALES | 92 | 363.57
EFT | P1 | 9286.44
[NAME] | 14 | 2200
SALES | 92 | 969
EFT | P1 | 3180.6
FOREIGN TRAVEL - CHINA | 41 | 25686
[NAME] (CHINA - TLP) | P4 | 2360.05
SALES | 92 | 10262.97
SALES | 92 | 6309.9
EFT | P1 | 18382.27
EFT | P1 | 9918
EFT | P1 | 2120.4
EFT | P1 | 1060.2
EFT | P1 | 957.6
EFT | P1 | 544.46
FOREIGN TRAVEL - CHINA | 41 | 520
EFT | P1 | 476.41
[NAME] (UK PERMALOK) | P3 | 39644.85
SALES | 92 | 209585.44
SALES | 92 | 35565.63
SALES | 92 | 7267.27
SALES | 92 | 2781.03
EFT | P1 | 9799.17
EFT | P1 | 734.84
[NAME] | 8 | 450
BANK CHARGES | 15 | 80
LOAN FROM JIKELELE | 88 | 600000
CREDIT CARD | P1 | 16209.41
[NAME] | 14 | 12794
[NAME] | 14 | 12430
EFT | P1 | 10117.39
[NAME] | 14 | 8227
[NAME] | 14 | 8201
[NAME] | 14 | 8193
[NAME] | 14 | 6336
[NAME] | 14 | 5756
EFT | P1 | 4288.68
[NAME] | 14 | 3800
EFT | P1 | 1026
[NAME] (CHINA - HANJIN) | P4 | 74125.2
[NAME] (CHINA - HULIFT) | P5 | 25265.3
TRAVELLING & ENTERTAINMENT | 13 | 11682
SALES | 92 | 88085.52
BANK CHARGES - REFUND | 103 | 37.12
BANK CHARGES | 15 | 1828.1
SALES | 92 | 47150.4
[NAME] | 14 | 3500
EFT | P1 | 3180.6
EFT | P1 | 161767.37
EFT | P1 | 72145.9
EFT | P1 | 8058.38
EFT | P1 | 1239.5
INTERNET BAND WIDTH | 26 | 96.19
SALES | 92 | 6271
SALES | 92 | 123896.14
SALES | 92 | 47776.55
SALES | 92 | 11690.98
SALES | 92 | 1749.9
EFT | P1 | 1700
INCORRECT PAYMENT
SECURITY SERVICE | 19 | 363
[NAME] | 8 | 200
SALES | 92 | 21375
SALES | 92 | 396157.56
SALES | 92 | 342141.46
SALES | 92 | 37734.21
SALES | 92 | 28904.56
SALES | 92 | 21375
INCORRECT PAYMENT REFUND
EFT | P1 | 8314.02
EFT | P1 | 1293.1
VEHICLE MAINTENANCE | 5 | 1054.5
CELLPHONE | 22 | 6993.31
ACCREDITATION | 32 | 703
INTERNET | 17 | 145
NEDFLEET : FUEL | 23 | 24372.19
BANK CHARGES | 15 | 891.77
INTEREST PAID | 31 | 422.9
TOLLGATE | 27 | 1373.9
VEHICLE MAINTENANCE | 5 | 12921.54
TELKOM | 11
LIGHTS + WATER | 4
P1 | PURCHASES (LOCAL)
P2 | PURCHASES (INDIRECT)
P3 | PURCHASES (UK)
P4 | PURCHASES (TLP)
P5 | PURCHASES (HANJIN)
P6 | PURCHASES (TANGS)
P7 | PURCHASES (HULIFT)
P8
P9
R | PURCHASES REFUND      DEDUCT   -
 | EXPENSES
4 | LIGHTS & WATER
5 | VEHICLE MAINTENANCE
6 | [NAME]
7 | SARS - PAYE
8 | DONATIONS
9 | STATIONERY
10 | DIVIDEND
11 | TELKOM
12 | SPONSORSHIP
13 | TRAVELLING, ACCOMODATION & ENT
14 | SALARIES & WAGES
15 | BANK CHARGES
16 | RENTAL
17 | INTERNET & NETWORKS
18 | INSURANCE
19 | SECURITY SERVICE (SECURE ACCESS)
20 | TRACKER + NETSTAR
21 | MEDICAL AID
22 | CELLULAR PHONES
23 | FUEL
24 | SARS - VAT
25 | AUDITORS FEE
26 | INTERNER CAPP
27 | TOLLGATE
28 | LEGAL COST
29 | COMPENSATION COMMISSIONER
30 | COURIER FEES
31 | INTEREST PAID
32 | ACCREDITATION
33 | RENOVATIONS
34 | ADVERTISING & PROMOTIONS
35 | TRAINING
36 | COMPUTER PROGRAM MAINTENANCE
37 | OFFICE EQUIPMENT
38 | SECRETARIAL FEES
39 | TRAFFIC FINES
40 | POSTAGE AND STAMPS
41 | FOREIGN TRAVEL
42 | PROPERTY VALUATION FEE
43 | PROVISIONAL TAX
44 | REPAIRS TO COMPUTERS
45 | SUNDRIES
46 | LABOUR CONSULTANT
47 | [NAME]
48 | DIVIDEND TAX
49 | SUBSCRIPTION
50
51
52
53
54
 | TOTAL EXPENSES
 | CAPITAL
55 | HP PAYMENT
56 | HP DEPOSITS
57 | CAPITAL PURCHASES
58 | CAPITAL EQUIPMENT
59
60 | HP SETTLEMENT
61 | HP DEPOSIT REFUNDED
 | LOANS
62 | LOANS TO KESHA
63 | LOANS REPAID BY KESHA
64 | LOANS TO BAMANI
65 | LOANS REPAID BY BAMANI
66 | LOANS TO K GOVINDER
67 | LOANS REPAID BY K GOVINDER
68 | LOANS TO R GOVINDER
69 | LOANS REPAID BY R GOVINDER
70 | LOANS TO UNIVERSAL
71 | LOANS REPAID BY UNIVERSAL
72 | LOANS TO JIKELELE
73 | LOANS REPAID BY JIKELELE
74 | LOANS TO Y PILLAY
75 | LOANS REPAID BY Y PILLAY
76 | LOANS TO EKOSTO
77 | LOANS REPAID BY EKOSTO
78
 | BORROWING
80 | BORROWING FROM KESHA
81 | BORROWING REPAID TO KESHA
82 | BORROWING FROM R GOVINDER
83 | BORROWING REPAID TO R GOVINDER
84 | BORROWING FROM Y PILLAY
85 | BORROWING REPAID TO Y PILLAY
86 | BORROWING FROM K GOVINDER
87 | BORROWING REPAID TO K GOVINDER
88 | BORROWING FROM JIKELELE
89 | BORROWING REPAID TO JIKELELE
90 | BORROWING FROM UNIVERSAL
91 | BORROWING REPAID TO UNIVERSAL
92 | SALES DEPOSIT
93 | SALES DEPOSIT REFUND
94 | SALES OF CAPITAL EQUIPMENT
95 | TRANSFER TO SAVINGS ACCOUNT
96 | UNPAID CHEQUES
97 | INCORRECT PAYMENT REFUNDED
98 | INCORRECT PAYMENTS RECEIVED
99 | INCORRECT PAYMENT MADE
100 | INTEREST RECEIVED
101 | FIXED INVESTMENTS
102 | INSURANCE REFUND CLAIM
103 | BANK CHARGES REFUND
104 | MADICAL AID REFUND