I have a document with som complicated furmulation that I put onto Google Sheets to get some help remotely as I am out of my depth. The solution was found (arrays) but now when I download it to use back on Excel, it pops up with errors..
Heres the comparison formulas

Sheets: =(K13)/ArrayFormula(sum(n(mmult(sequence(1,rows($D$2:$D$9),1,0),($D$2:$J$9<>"") * (hlookup(B$2:B$9,$N$11:$U$22, (row()-10),false)<>""))>0)))
Excel: {=(K13)/SUM(N(MMULT(sequence(1,ROWS($D$2:$D$9),1,0),($D$2:$J$9<>"") * (HLOOKUP(B$2:B$9,$N$11:$U$22, (ROW()-10),FALSE)<>""))>0))}

I know Excel converts ArrayFormula() to {}, but other than that I'm at a loss...