Spreadsheet: 718095d1612980801-sum-3-columns-based-on-4-criterias-sum-if-4-criterias-are-met
Sheet: MTP Portfolio TWR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Today | 2021-01-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like to sum "Fees, Commissiom, Amount" associated to (Symbol in T4) with multiple criterias of Type "PUT" & Side "SELL" (in Column V&Y) only if [NAME] in column X are Less than date in Cell S3. Result in Cell X3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basically, If in Column V there are puts, then if in Column Y there ase [NAME], and if symbol in Column Z equals to Symbol in in Cell T4, then if their dates are less than date in Cell S3  then sum fees, commission and amount orelse zero
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have attempted to write the formula currently in the yellow but I wasn’t able to join all the criterias.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Same will Be applied for the BUY Side
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thank you:)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type |  | Date | Side | Symbol | QTY | Strike | Price | Fees | Commissions |  | AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2020-04-24 00:00:00 | SELL | AGNC | 3 | 11 | 0.42 | -0.07 | -1.95 |  | 126
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2020-04-24 00:00:00 | SELL | AGNC | 3 | 11 | 0.42 | -0.07 | -1.95 |  | 126
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2020-04-24 00:00:00 | SELL | AGNC | 4 | 11 | 0.42 | -0.09 | -2.6 |  | 168
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2023-01-20 00:00:00 | SELL | NLY | 5 | 10 | 3.65 | -0.13 | -3.25 |  | 1825
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2020-10-16 00:00:00 | BUY | NLY | 4 | 6 | 0.05 | -0.07 | 0 |  | -20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STOCK |  |  | BUY | NLY | 100 |  | 8 | -0.07 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2020-10-16 00:00:00 | BUY | NLY | 2 | 6 | 0.05 | -0.03 | 0 |  | -10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2023-01-20 00:00:00 | SELL | NLY | 5 | 10 | 4.1 | -0.13 | -3.25 |  | 2050
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STOCK |  |  | SELL | NLY | 100 |  | 8.5 | -0.09 | -3.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2023-01-20 00:00:00 | SELL | NLY | 2 | 10 | 4.25 | -0.05 | -1.3 |  | 850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2020-11-20 00:00:00 | BUY | NLY | 20 | 7 | 0.04 | -0.28 | 0 |  | -80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2021-01-15 00:00:00 | SELL | NLY | 10 | 8 | 0.92 | -0.18 | -6.5 |  | 920
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2023-01-20 00:00:00 | SELL | NLY | 1 | 10 | 4.2 | -0.02 | -0.65 |  | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2021-07-16 00:00:00 | SELL | NLY | 5 | 8 | 1 | -0.09 | -3.25 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2021-01-15 00:00:00 | BUY | NLY | 10 | 6 | 0.02 | -0.14 | 0 |  | -20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2021-01-15 00:00:00 | BUY | NLY | 10 | 6 | 0.02 | -0.14 | 0 |  | -20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STOCK |  |  | BUY | NLY | 200 |  | 8.25 | -0.05 | -1.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2020-12-18 00:00:00 | BUY | NLY | 5 | 8 | 0.01 | -0.07 | 0 |  | -5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2021-01-15 00:00:00 | SELL | NLY | 10 | 8.5 | 0.39 | -0.17 | -6.5 |  | 390
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2021-01-15 00:00:00 | SELL | NLY | 8 | 8.5 | 0.41 | -0.14 | -5.2 |  | 328
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUT |  | 2021-01-15 00:00:00 | BUY | NLY | 2 | 7 | 0.01 | -0.03 | 0 |  | -2