Spreadsheet: 120066d1314963533-adding-values-based-on-both-month-and-text-criteria-example
Sheet: Jul

Category | Date | Description | Credit | Debit | Running Balance
social | 2011-07-30 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 401542BURPHAM E, BURPHAM E1 B, 40.00 GBP, ON 30-07-20 |  | -40 | 5338.61
Salary | 2011-07-29 00:00:00 | BANK GIRO CREDIT REF ICEGRADE LTD, ICEGRADE | 2047.29 |  | 5378.61
Phone | 2011-07-28 00:00:00 | DIRECT DEBIT PAYMENT TO VODAFONE LIMITED REF 25984152M058734, MANDATE NO 0004 |  | -40.74 | 3331.32
Petrol | 2011-07-26 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,50.02 GBP ON 24-07-2011 |  | -50.02 | 3372.06
Misc | 2011-07-26 00:00:00 | CARD PAYMENT TO CHESSINGTON WORLD,64.00 GBP ON 23-07-2011 |  | -64 | 3422.08
Misc | 2011-07-26 00:00:00 | CARD PAYMENT TO SONCO LTD - COLLEG,15.50 GBP ON 22-07-2011 |  | -15.5 | 3486.08
social | 2011-07-23 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 401542BURPHAM E, BURPHAM E1 B, 30.00 GBP, ON 23-07-20 |  | -30 | 3501.58
Misc | 2011-07-23 00:00:00 | CARD PAYMENT TO TICKETOFFICESALE,2.90 GBP ON 21-07-2011 |  | -2.9 | 3531.58
Car Service/MOT | 2011-07-23 00:00:00 | CARD PAYMENT TO CAMBERLEY SEAT,186.64 GBP ON 21-07-2011 |  | -186.64 | 3534.48
Car Service/MOT | 2011-07-23 00:00:00 | CARD PAYMENT TO SELFSERVE TICKET,10.20 GBP ON 21-07-2011 |  | -10.2 | 3721.12
social | 2011-07-22 00:00:00 | CASH WITHDRAWAL AT TESCO PERSONAL FINANCE ATM TESCO K UPN TH, KINGSTON UPON T, 30.00 GBP, |  | -30 | 3731.32
Food | 2011-07-22 00:00:00 | CARD PAYMENT TO TESCO STORES 6156,3.07 GBP ON 20-07-2011 |  | -3.07 | 3761.32
Food | 2011-07-21 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,3.07 GBP ON 19-07-2011 |  | -3.07 | 3764.39
Food | 2011-07-19 00:00:00 | CARD PAYMENT TO FORBUOYS,3.69 GBP ON 16-07-2011 |  | -3.69 | 3767.46
Food | 2011-07-16 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,6.16 GBP ON 14-07-2011 |  | -6.16 | 3771.15
Dentist | 2011-07-15 00:00:00 | CARD PAYMENT TO APEX DENTAL CARE LTD,26.00 GBP ON 13-07-2011 |  | -26 | 3777.31
Food | 2011-07-15 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,2.50 GBP ON 13-07-2011 |  | -2.5 | 3803.31
Misc | 2011-07-14 00:00:00 | CARD PAYMENT TO NATIONAL LOTTERY INTE,12.00 GBP ON 12-07-2011 |  | -12 | 3805.81
Petrol | 2011-07-14 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,53.36 GBP ON 12-07-2011 |  | -53.36 | 3817.81
Misc | 2011-07-13 00:00:00 | CARD PAYMENT TO FORBUOYS,5.71 GBP ON 10-07-2011 |  | -5.71 | 3871.17
Food | 2011-07-12 00:00:00 | CARD PAYMENT TO TESCO STORE 2590,58.34 GBP ON 10-07-2011 |  | -58.34 | 3876.88
Clothes | 2011-07-12 00:00:00 | CARD PAYMENT TO WWW.ASOS.COM,321.00 GBP ON 09-07-2011 |  | -321 | 3935.22
Misc | 2011-07-12 00:00:00 | CARD PAYMENT TO WOKING BREWERY ROAD,1.10 GBP ON 09-07-2011 |  | -1.1 | 4256.22
social | 2011-07-07 00:00:00 | CASH WITHDRAWAL AT Forbuoys, 87 Hi [NAME], 87 Hi, Horsell HF, 60.99 GBP, ON 07-07-20 |  | -60.99 | 4257.32
 | 2011-07-07 00:00:00 | INTEREST PAID AFTER TAX 0.41 DEDUCTED | 1.64 |  | 4318.31
Petrol | 2011-07-07 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,50.14 GBP ON 05-07-2011 |  | -50.14 | 4316.67
Food | 2011-07-05 00:00:00 | CARD PAYMENT TO MCDONALDS REST.,0.99 GBP ON 02-07-2011 |  | -0.99 | 4366.81
social | 2011-07-05 00:00:00 | CARD PAYMENT TO SHIP,45.00 GBP ON 02-07-2011 |  | -45 | 4367.8
social | 2011-07-05 00:00:00 | CARD PAYMENT TO SELFSERVE TICKET,15.20 GBP ON 02-07-2011 |  | -15.2 | 4412.8
Food | 2011-07-05 00:00:00 | CARD PAYMENT TO SAINSBURYS S/MKTS,7.65 GBP ON 02-07-2011 |  | -7.65 | 4428
social | 2011-07-04 00:00:00 | CASH WITHDRAWAL AT LLOYDS TSB BANK PLC ATM WOKING (309980), WOKING, 50.00 GBP, ON 02-07-20 |  | -50 | 4435.65
social | 2011-07-02 00:00:00 | CASH WITHDRAWAL AT NATIONAL WESTMINSTER BANK ATM WOKING, WOKING, 50.00 GBP, ON 02-07-2011 |  | -50 | 4485.65
Rent | 2011-07-01 00:00:00 | REGULAR TRANSFER PAYMENT TO ACCOUNT 090133 29153404, MANDATE NO 1 |  | -100 | 4535.65
 |  |  | 2048.93 | -1345.97