Sum amounts based on criteria for unique combinations of fields in an Excel Table

I have a Table in Excel 365 called MyLongData that contains multiple rows. I would like to come up with a formula that tracks claims, where a claim is defined as a unique combination of fields [Accident Date], [Claimant Name], [Location].

I want to add up the [Amount] field for claims where [Amount]>10000, furthermore, I want to restrict it to where field [Year] = 2023.

So to summarize, I would like to add up [Amount] given [Amount]>10000 grouped by combination of [Accident Date], [Claimant Name], [Location] in a table MyLongData.

Simple example:

I want to return 10050 (the sum of records 2 and 3, which are a single claim that exceeds the 10000 threshold).

I managed to figure out the formula for the COUNTS, which I believe is correct:

=IFERROR(ROWS(UNIQUE(FILTER(
MyLongData[Accident Date]&MyLongData[Location]&MyLongData[Claimant Name],
(MyLongData[Year]=2023)*(SUMIFS(MyLongData[Amount],
MyLongData[Accident Date],MyLongData[Accident Date],
MyLongData[Location],MyLongData[Location],
MyLongData[Claimant Name],
MyLongData[Claimant Name])>10000)))),0)

But I can't get the formula to add up the amounts.

I'd prefer a single (however complex) formula, but I can also resort to a Pivot Table approach, if that's the only way.

Here is one way of achieving the desired output:

=LET(
     _SumByYear, SUMIFS(Amount,Accident_Date,Accident_Date,
                               Claimant_Name,Claimant_Name,
                               Location,Location,Year,2023),
     UNIQUE(FILTER(HSTACK(DROP(MyLongData,,-1),_SumByYear),
                   _SumByYear>10000,0)))

Or Better with using GROUPBY() if applicable:

=LET(
     _Group, GROUPBY(MyLongData[[Accident Date]:[Year]],Amount,SUM,,0,,Year=2023),
     FILTER(_Group, TAKE(_Group,,-1)>10000,0))

_{NOTE: Firstly, using Structured References aka Tables, secondly to make easier to read have defined those references with their respective column heads. Please ensure to change the references or cell ranges etc as per your suit. GROUPBY() function works with MS365 Office Insiders Version Exclusively.}