Spreadsheet: 138629d1327770426-sumproduct-index-and-left-dummy-book3
Sheet: Dummy

Date | Ref | Details | Bank | Cash | Sales | Letting/  Rent | Private | Sundry Receipts | Bank Interest | Capital | DayBook Receit | Bank/     Cash |  | Date | Invoice Ref | Payment Method | Payment Details | Bank | Cash | Drawings | Purshases of Stock/    Materials | Tool,Weather/Safety equip | Repairs & Renewals | Motor Expenses | Hire Charges | N.I cont / TGWU | [NAME]   Stationary | Misc | Acquisition of Assets | Let  Property | Purchase Day Book Payments | Bank Charges | Utilities / House | Income Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date | Invoice Ref | Payment Method | Payment Details | Bank | Cash | Drawings | Purshases of Stock/    Materials | Tool,Weather/Safety equip | Repairs & Renewals | Motor Expenses | Hire Charges | Liability    Insur | N.I | [NAME]   Stationary | Misc | Acquisition of Assets | Let  Property | Bank Charges | Utilities / House | Income Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-23 00:00:00 | [NAME] | Transf | [NAME] | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-24 00:00:00 |  | D. Debit | Tower Risk | 1 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-26 00:00:00 | gs0085 | My Joint | BB Computers | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-26 00:00:00 |  | D. Debit | HH Insurance | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-26 00:00:00 |  | My Joint | Post Office | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-26 00:00:00 | gs0090 | My Joint | Phone W/house | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-26 00:00:00 | gs0095 | My Joint | Talk Talk | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-27 00:00:00 | Missing | F D cheq  100144 | AB Printers | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-27 00:00:00 |  | My Joint | Post Office | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-28 00:00:00 | p0090 | My Joint | ZZ Stationary | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-28 00:00:00 | gs0095 | D. Debit | Data Insurance | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-30 00:00:00 |  | [NAME] | Shop rent | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-30 00:00:00 |  | D. Debit | Orange | 1 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-30 00:00:00 | gs0100 | Cash | AB Wages |  | 1 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00 |  | D. Debit | Home Broadband | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-04 00:00:00 |  | D. Debit | Water | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Totals for each payment method | Totals for                                                                Totals by |  | Drawings | Purshases of Stock/    Materials | Tool,Weather/Safety equip | Repairs & Renewals | Motor Expenses | Hire Charges | Liability    Insur | N.I | [NAME]   Stationary | Misc | Acquisition of Assets | Let  Property | Bank Charges | Utilities / House | Income Tax
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | My Joint
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jill Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Draw Cash
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D. Debit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F D cheq
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | AB Wages | Others | Orange | Data Insurance | Home Broadband | Office | Tower Risk | Council | Water | Elec | Oil | HH Insurance | Talk Talk | Shop rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Roll Expen | Month Exp less Acq&Let | Total Roll Month Exp less Acq&Let | Income for Month | Total      Roll inco
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "= IF(SUMPRODUCT(--($R$7:$R$22=(LEFT($R$7:$R$22,6)="Office")))>=ROWS(S$48:S48),INDEX($AC$7:$AC$22,SMALL(IF($R$7:$R$22=(LEFT($R$7:$R$22,6)="Office"),ROW($R$7:$R$22)-ROW($R$7)+1),ROWS(S$48:S48))),"")"