Create formula without error?

[kmlunde]

Is it some way to write this formula so that it will not end up with the error "we found a problem with some content"?
$xlsx.Totals.Cells['A4'].Formula = '=SORT(UNIQUE(TRIM(TEXTSPLIT(TEXTJOIN(",";;tblLicense[extensionAttribute12]);;","))))' $xlsx.Totals.Cells['B4'].Formula = '=COUNTIF(tblLicense[extensionAttribute12];"*"&A4&"*"'

Now I add them to the spreadsheet as values and then an instruction info in the file.
$xlsx.Totals.Cells['A1'].Value = 'Click in each formula-cell, click in formula-bar and presse enter in each to populate formula, then copy formula from B4 to all cells below'

The data for extensionAttribute12 is like different comma separated values like this:
Dynamics_365_Business_Central_Team_Members,E3,FLOW_FREE,INTUNE_VL,M365_Copilot,P1,POWER_BI_PRO

And being in Norway we use ";" as separator in Excel