Spreadsheet: 694653d1599737109-excel-lookup-and-countif-issue-example-100920
Sheet: Transactions

Name | Type | £ | Volume | Value | £ Price | Price | Currency | Rate | Value | Date | Summary | MarketName | Period | ProfitAndLoss | Transaction type | Reference | Open level | Close level | Size | Currency | PL Amount | Cash transaction | DateUtc | OpenDateUtc | CurrencyIsoCode
A/C | - |  | 2
A/C | - |  | 3
A/C | - |  | 4
A/C | - |  | 5
Amazon | Buy |  |  |  |  |  |  |  |  | 2020-03-09 00:00:00 | Client Consideration | Leverage Shares 2x Amazon ETP CONS 60@4137 P8S83:927403~34750 Converted at 0.77840601037830 | - | -193.22 | WITH | 24128175 | - | 0 | - | £ | -193.22 | False | 2020-03-09T07:18:52 | 2020-03-09T07:18:52 |  | CONS | Converted at | @
Amazon | Fee |  |  |  |  |  |  |  |  | 2020-07-02 00:00:00 | Share Dealing Commissions | Leverage Shares 2x Amazon ETP COMM P8S83:1015213~23336 | - | -3 | WITH | 31609176 | - | 0 | - | £ | -3 | False | 2020-07-02T11:15:21 | 2020-07-02T11:15:21 |  | CONS | Converted at | @
Amazon | Fee |  |  |  |  |  |  |  |  | 2020-03-05 00:00:00 | Share Dealing Commissions | Leverage Shares 2x Amazon ETP COMM P8S83:927403~34750 | - | -8 | WITH | 41633204 | - | 0 | - | £ | -8 | False | 2020-03-05T12:30:00 | 2020-03-05T12:30:00 |  | CONS | Converted at | @
Amazon | Sell |  |  |  |  |  |  |  |  | 2020-07-07 00:00:00 | Client Consideration | Leverage Shares 2x Amazon ETP CONS 30@8590 P8S83:1015213~23336 Converted at 0.795732315649490 | - | 205.06 | DEPO | 23178207 | - | 0 | - | £ | 205.06 | False | 2020-07-07T13:56:26 | 2020-07-07T13:56:26 |  | CONS | Converted at | @
[NAME] | Buy |  |  |  |  |  |  |  |  | 2020-03-06 00:00:00 | Client Consideration | CRISPR Therapeutic SA CONS 40@5247 P8S83:927399~31271 Converted at 0.784451775533910 | - | -164.64 | WITH | 41443204 | - | 0 | - | £ | -164.64 | False | 2020-03-06T12:11:15 | 2020-03-06T12:11:15 |  | CONS | Converted at | @
[NAME] | Fee |  |  |  |  |  |  |  |  | 2020-03-04 00:00:00 | Share Dealing Commissions | CRISPR Therapeutic SA COMM P8S83:927399~31271 | - | -10 | WITH | 41856165 | - | 0 | - | £ | -10 | False | 2020-03-04T14:30:04 | 2020-03-04T14:30:04 |  | CONS | Converted at | @
Gilead Sciences | Buy |  |  |  |  |  |  |  |  | 2020-03-06 00:00:00 | Client Consideration | Gilead Sciences Inc (All Sessions) CONS 30@7489 P8S83:927396~30090 Converted at 0.784952652906135 | - | -176.36 | WITH | 41827165 | - | 0 | - | £ | -176.36 | False | 2020-03-06T16:42:44 | 2020-03-06T16:42:44 |  | CONS | Converted at | @
Gilead Sciences | Dividend |  |  |  |  |  |  |  |  | 2020-06-30 00:00:00 | Dividend | Gilead Sciences Inc DIVIDEND 30@0.57799977 Converted at 0.80942513 | - | 14 | DEPO | 31796166 | - | 0 | - | £ | 1.4 | False | 2020-06-30T05:32:08 | 2020-06-30T05:32:08 |  | CONS | Converted at | @
Gilead Sciences | Dividend |  |  |  |  |  |  |  |  | 2020-03-31 00:00:00 | Dividend | Gilead Sciences Inc DIVIDEND 3@0.57799953 Converted at 0.80663500 | - | 14 | DEPO | 41297202 | - | 0 | - | £ | 1.4 | False | 2020-03-31T04:58:59 | 2020-03-31T04:58:59 |  | CONS | Converted at | @
Gilead Sciences | Fee |  |  |  |  |  |  |  |  | 2020-03-04 00:00:00 | Share Dealing Commissions | Gilead Sciences Inc (All Sessions) COMM P8S83:927396~30090 | - | -10 | WITH | 24161202 | - | 0 | - | £ | -10 | False | 2020-03-04T14:35:32 | 2020-03-04T14:35:32 |  | CONS | Converted at | @
[NAME] | Buy |  |  |  |  |  |  |  |  | 2020-03-06 00:00:00 | Client Consideration | GlaxoSmithKline PLC - ADR CONS 50@4228 P8S83:927396~30833 Converted at 0.784451775533910 | - | -165.83 | WITH | 41986175 | - | 0 | - | £ | -165.83 | False | 2020-03-06T12:19:26 | 2020-03-06T12:19:26 |  | CONS | Converted at | @
[NAME] | Dividend |  |  |  |  |  |  |  |  | 2020-07-13 00:00:00 | Dividend | GlaxoSmithKline PLC DIVIDEND 50@0.46641371 Converted at 0.78933705 | - | 18.4 | DEPO | 31861208 | - | 0 | - | £ | 1.84 | False | 2020-07-13T17:32:26 | 2020-07-13T17:32:26 |  | CONS | Converted at | @
[NAME] | Fee |  |  |  |  |  |  |  |  | 2020-03-04 00:00:00 | Share Dealing Commissions | GlaxoSmithKline PLC - ADR COMM P8S83:927396~30833 | - | -10 | WITH | 41847175 | - | 0 | - | £ | -10 | False | 2020-03-04T14:30:07 | 2020-03-04T14:30:07 |  | CONS | Converted at | @