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

Category | Date | Description | Credit | Debit | Running Balance
Phone | 2011-05-31 00:00:00 | DIRECT DEBIT PAYMENT TO VODAFONE LIMITED REF 25984152M560134, MANDATE NO 0004 |  | -40.09 | 3159.5
Salary | 2011-05-31 00:00:00 | BANK GIRO CREDIT REF ICEGRADE LTD, ICEGRADE | 2106.64 |  | 3199.59
Holiday 2011 | 2011-05-30 00:00:00 | [NAME] TO [NAME] REFERENCE VEGAS - SAM & STEF, MANDATE NO 0009 |  | -415 | 1092.95
Misc | 2011-05-30 00:00:00 | CARD PAYMENT TO WAITROSE 181,3.50 GBP ON 27-05-2011 |  | -3.5 | 1507.95
Holiday 2011 | 2011-05-27 00:00:00 | CASH WITHDRAWAL AT TRAVELEX [NAME], LONDON, 40.00 GBP, ON 27-05-2011 |  | -40 | 1511.45
Holiday 2011 | 2011-05-24 00:00:00 | CARD PAYMENT TO BOOTS 0898,15.96 GBP ON 21-05-2011 |  | -15.96 | 1551.45
Holiday 2011 | 2011-05-24 00:00:00 | CARD PAYMENT TO VROOM LOUNGE,14.00 GBP ON 21-05-2011 |  | -14 | 1567.41
Holiday 2011 | 2011-05-24 00:00:00 | CARD PAYMENT TO EXCESS BAGGAGE CO,12.99 GBP ON 21-05-2011 |  | -12.99 | 1581.41
Holiday 2011 | 2011-05-24 00:00:00 | CARD PAYMENT TO WH SMITH,11.72 GBP ON 21-05-2011 |  | -11.72 | 1594.4
Holiday 2011 | 2011-05-23 00:00:00 | CARD PAYMENT TO VIRGIN TRAVEL INSUR,35.59 GBP ON 19-05-2011 |  | -35.59 | 1606.12
Holiday 2011 | 2011-05-21 00:00:00 | CARD PAYMENT TO H & M,79.95 GBP ON 19-05-2011 |  | -79.95 | 1641.71
Holiday 2011 | 2011-05-21 00:00:00 | CARD PAYMENT TO RIVER ISLAND 107,34.99 GBP ON 19-05-2011 |  | -34.99 | 1721.66
Misc | 2011-05-19 00:00:00 | CASH WITHDRAWAL AT TESCO PERSONAL FINANCE ATM TESCO K UPN TH, KINGSTON UPON T, 20.00 GBP, |  | -20 | 1756.65
Misc | 2011-05-19 00:00:00 | CARD PAYMENT TO WWW.OXFORDSHIRE.GOV.UK,30.00 GBP ON 17-05-2011 |  | -30 | 1776.65
Misc | 2011-05-18 00:00:00 | CARD PAYMENT TO BOOTS,GUILDFORD,6.12 GBP ON 15-05-2011 |  | -6.12 | 1806.65
Misc | 2011-05-17 00:00:00 | CARD PAYMENT TO WWW.SKYBET.COM,10.00 GBP ON 14-05-2011 |  | -10 | 1812.77
Holiday 2011 | 2011-05-17 00:00:00 | CARD PAYMENT TO HOUSE OF FRASER,65.99 GBP ON 15-05-2011 |  | -65.99 | 1822.77
Holiday 2011 | 2011-05-17 00:00:00 | CARD PAYMENT TO DEBENHAMS,57.00 GBP ON 15-05-2011 |  | -57 | 1888.76
Holiday 2011 | 2011-05-17 00:00:00 | CARD PAYMENT TO RIVER ISLAND 129,6.99 GBP ON 15-05-2011 |  | -6.99 | 1945.76
Holiday 2011 | 2011-05-17 00:00:00 | CARD PAYMENT TO H & M,67.97 GBP ON 14-05-2011 |  | -67.97 | 1952.75
Holiday 2011 | 2011-05-17 00:00:00 | CARD PAYMENT TO NEXT 0528, WOKING PEAC,28.00 GBP ON 14-05-2011 |  | -28 | 2020.72
Misc | 2011-05-17 00:00:00 | CARD PAYMENT TO WOKING BREWERY ROAD,2.20 GBP ON 14-05-2011 |  | -2.2 | 2048.72
[NAME] | 2011-05-17 00:00:00 | CARD PAYMENT TO PKRSER.COM/[PHONE] ON 2011-05-14 |  | -15.43 | 2050.92
[NAME] | 2011-05-17 00:00:00 | CREDIT FROM PKRSER.COM/35020072800ON 2011-05-14 | 11.06 |  | 2066.35
[NAME] | 2011-05-17 00:00:00 | CREDIT FROM WWW.SKYBET.COMON 2011-05-14 | 10 |  | 2055.29
Misc | 2011-05-16 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,2.38 GBP ON 13-05-2011 |  | -2.38 | 2045.29
Holiday 2011 | 2011-05-14 00:00:00 | CARD PAYMENT TO WWW.ONLINEFX.CO.UK,355.03 GBP ON 11-05-2011 |  | -355.03 | 2047.67
Petrol | 2011-05-14 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,63.47 GBP ON 12-05-2011 |  | -63.47 | 2402.7
Misc | 2011-05-12 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 400129KINGSTON, KINGSTON MNY B, 10.00 GBP, ON 12-05-2 |  | -10 | 2466.17
Food | 2011-05-12 00:00:00 | CARD PAYMENT TO TESCO STORES 6156,2.54 GBP ON 10-05-2011 |  | -2.54 | 2476.17
Misc | 2011-05-12 00:00:00 | CARD PAYMENT TO SUPERDRUG STORES PLC,1.99 GBP ON 10-05-2011 |  | -1.99 | 2478.71
Food | 2011-05-11 00:00:00 | CARD PAYMENT TO TESCO STORES SACAT,2.43 GBP ON 09-05-2011 |  | -2.43 | 2480.7
Social | 2011-05-10 00:00:00 | CARD PAYMENT TO W M MORRISONS,70.06 GBP ON 07-05-2011 |  | -70.06 | 2483.13
Clothes | 2011-05-09 00:00:00 | CARD PAYMENT TO [NAME] GBP ON 06-05-2011 |  | -19 | 2553.19
 | 2011-05-07 00:00:00 | INTEREST PAID AFTER TAX 0.41 DEDUCTED | 1.63 |  | 2572.19
Social | 2011-05-06 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 403534OXFORD CO, OXFORD CORN I B, 40.00 GBP, ON 06-05 |  | -40 | 2570.56
Holiday 2011 | 2011-05-05 00:00:00 | CARD PAYMENT TO WWW.FAIRFX.COM,2,198.08 GBP ON 03-05-2011 |  | -384 | 2610.56
Misc | 2011-05-05 00:00:00 | CARD PAYMENT TO SANTANDER CARDS UK,321.06 GBP ON 03-05-2011 |  | -321.06 | 4808.64
Misc | 2011-05-04 00:00:00 | CASH WITHDRAWAL AT HSBC BANK PLC ATM 400129KINGSTON, KINGSTON MNY B, 10.00 GBP, ON 04-05-2 |  | -10 | 5129.7
Petrol | 2011-05-04 00:00:00 | CARD PAYMENT TO SAINSBURYS PETROL,55.47 GBP ON 02-05-2011 |  | -55.47 | 5139.7
Misc | 2011-05-04 00:00:00 | CARD PAYMENT TO SACAT SAINSBURYS,6.86 GBP ON 02-05-2011 |  | -6.86 | 5195.17
 | 2011-05-03 00:00:00 | FASTER PAYMENTS RECEIPT FROM SR CIONI |  |  | 5202.03 | 800
 | 2011-05-03 00:00:00 | FASTER PAYMENTS RECEIPT FROM MR L A MILLER |  |  | 4402.03 | 200
Rent | 2011-05-03 00:00:00 | REGULAR TRANSFER PAYMENT TO ACCOUNT 090133 29153404, MANDATE NO 1 |  | -100 | 4202.03
Food | 2011-05-03 00:00:00 | CARD PAYMENT TO SAINSBURY'S S/MKT,38.28 GBP ON 01-05-2011 |  | -38.28 | 4302.03
Gym | 2011-05-03 00:00:00 | DIRECT DEBIT PAYMENT TO WOKING BC REF 510353, MANDATE NO 0003 |  | -38 | 4340.31
Phone | 2011-05-03 00:00:00 | DIRECT DEBIT PAYMENT TO VODAFONE LIMITED REF 25984152M367979, MANDATE NO 0004 |  | -37.94 | 4378.31
Misc | 2011-05-02 00:00:00 | CARD PAYMENT TO W M MORRISONS,17.71 GBP ON 29-04-2011 |  | -17.71 | 4416.25
 |  |  | 2129.33 | -2589.71