Spreadsheet: 875989d1722618271-nested-countifs-formula-that-needs-additional-logic-formula-checks-within-sample-data
Sheet: Sheet1

Date Added to Tracker | Opportunity ID (18 digits) | Amount | Opp ID on [NAME]?
2023-06-28 00:00:00 | 0064L00000EWnQLQA1 | 15900000 | No |  | FY23 | 2022-07-01 00:00:00
2023-06-28 00:00:00 | 0064L00000EWnQLQA1 | 15900000 | No |  | FY23 | 2023-06-30 00:00:00
2023-06-29 00:00:00 | 0064L00000EryDuQAJ | 7000000 | No |  | FY24 | 2023-07-01 00:00:00
2023-07-17 00:00:00 | 0064L00000DAvNnQAL | 2325000 | No |  | FY24 | 2024-06-30 00:00:00
2023-07-17 00:00:00 | 0064L00000DAvNnQAL | 2325000 | No |  | FY25 | 2024-07-01 00:00:00
2023-07-17 00:00:00 | 0064L00000FzY2wQAF | 25000000 | No |  | FY25 | 2025-06-30 00:00:00
2023-07-19 00:00:00 | Confidential |  | No
2023-07-19 00:00:00 | [NAME] |  | No |  | FY23
2023-07-19 00:00:00 | 0064L00000F7EP6QAN | 9471351 | No |  | <$2m | 1999999 |  | includes blanks
2023-07-19 00:00:00 | 0064L00000FxiC8QAJ | 2650000 | No |  | $2m+ | 2000000
2023-07-19 00:00:00 | Confidential |  | No |  | $2m+ | 4999999
2023-07-19 00:00:00 | Confidential |  | No |  | $5m+ | 5000000
2023-07-19 00:00:00 | 0064L00000Fsv6JQAR | 2000000 | No |  | $5m+ | 9999999
2023-07-19 00:00:00 | 0064L00000DANUiQAP | 630000 | No |  | $10m+ | 10000000
2023-07-19 00:00:00 | 0064L00000EsrISQAZ |  | No
2023-07-20 00:00:00 | SF Locked |  | No |  | FY24
2023-07-20 00:00:00 | 0064L00000FzZzVQAV | 2400000 | No |  | <$2m | 1999999
2023-07-20 00:00:00 | 0064L00000FzZzVQAV | 2400000 | No |  | $2m+ | 2000000
2024-06-27 00:00:00 | Confidential |  | Yes |  | $2m+ | 4999999
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes |  | $5m+ | 5000000
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes |  | $5m+ | 9999999
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes |  | $10m+ | 10000000
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes |  | FY25
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes |  | <$2m | 1999999
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes |  | $2m+ | 2000000
2024-06-27 00:00:00 | 0064L00000HOHq9QAH | 4500000 | Yes |  | $2m+ | 4999999
2024-06-28 00:00:00 |  |  |  |  | $5m+ | 5000000
2024-06-28 00:00:00 | 0064L00000FwqNdQAJ | 500000 | No |  | $5m+ | 9999999
2024-06-28 00:00:00 | 006Vl0000082R9OIAU | 760743 | No |  | $10m+ | 10000000
2024-06-28 00:00:00
2024-06-28 00:00:00 | 006Vl000006GPJxIAO | 6950000 | No
2024-06-28 00:00:00 | 006Vl00000AIMcDIAX | 950000 | No
2024-06-28 00:00:00 | 006Vl00000AIMcDIAX | 950000 | No
2024-06-28 00:00:00 | 006Vl00000AIMcDIAX | 950000 | No
2024-06-28 00:00:00 | 0064L00000D9iNjQAJ |  | Yes
2024-06-28 00:00:00 | 006Vl000009pAEfIAM | 3500000 | No
2024-06-28 00:00:00 | 0064L00000HOEF6QAP | 3000000 | No
2024-07-09 00:00:00 | [NAME] | 1722853 | Yes
2024-07-09 00:00:00 | 006Vl00000AD3S9IAL | 12000000 | No
2024-07-09 00:00:00 | 006Vl00000AD3S9IAL | 12000000 | No
2024-07-09 00:00:00 | 006Vl00000AD3S9IAL | 12000000 | No
2024-07-10 00:00:00 | 006Vl00000AD2CjIAL |  | Yes
2024-07-10 00:00:00 | 006Vl00000AD2CjIAL |  | Yes
2024-07-10 00:00:00 | 006Vl00000AD2CjIAL |  | Yes
2024-07-10 00:00:00 | 006Vl00000AD2CjIAL |  | Yes
2024-07-15 00:00:00 | 006Vl0000081Zf5IAE | 8100000 | Yes
2024-07-15 00:00:00 | Not linked |  | No