Formula language problem

[madocar]

Hello,

I'm from Slovakia and I use excel in Slovak language.
I have set some formulas and when It's open in Czech republic, an error has occured.
The formula just does not work at all.

Sheet name:
Error_sheet

Formula Cell:
G5

Formula:

=D5-SUM(((Table_3[Začiatok prenájmu]<=$G$2)*(Table_3[Koniec prenájmu]>=$G$2)*(INDIRECT("'Prenajatá technika'!AL5:"&ADDRESS(ROWS('Prenajatá technika'!$DA$5#)+4;COLUMN('Prenajatá technika'!DA1);1;;))=F5)))

Error type:
#NAME?

Please could you help me out.
More in attachment

Thank you
Matt

 

[vletm]

madocar
Your G5 formula is different than Your above given ... why?
If You would use Your given formula with modification from $DA$5# to $DA$5
then for me it gives ... #VALUE!.
K-column formulas has some #REF!'s.
PS. Your Excel is newer than mine ... it give some notes too.
Your given filename has at least one illegal character.

 

[madocar]

Hi vletm,

thank you for replying.

K column - we can ignore.
Correct formula is with $DA$5#, so:

=D5-SUM(((Table_3[Začiatok prenájmu]<=$G$2)*(Table_3[Koniec prenájmu]>=$G$2)*(INDIRECT("'Prenajatá technika'!AL5:"&ADDRESS(ROWS('Prenajatá technika'!$DA$5#)+4;COLUMN('Prenajatá technika'!DA1);1;;))=F5)))

Does it work for you?

Look at my gif file how it might look.
Thank you

 

[vletm]

madocar
With my Excel with # it won't work at all.
Maybe someone else would help You ... after You've given Your Excel-version.

 

[Debaser]

What version of Office does the Czech user have?

 

[madocar]

Microsoft 2016 version of 2303

 

[Debaser]

If they don't have M365 then the FILTER function that you have used would result in a #NAME? error which would then flow through your formulas, and the spill range syntax also won't work.

 

[madocar]

@Debaser !
Thank you very much
You helped me a lot!