CONT.SES BETWEEN DIFFERENT LIBREOFFICE / EXCEL FILES

0

I'm using CONT.SES between different files , but I'm getting:

  

ERROR: 504.

The formula looks like this:

=CONT.SES('file:///C:/Users/jaciel.barros/Desktop/RELATÓRIOS/JANEIRO2016.ods'#$JANEIRO.$O$3:$O$75;"SIM";'file:///C:/Users/jaciel.barros/Desktop/RELATÓRIOS/JANEIRO2016.ods'#$JANEIRO.$L$3:$L$75;"GURGEL")
    
asked by anonymous 18.08.2016 / 17:57

1 answer

0

Error 504 = > Error in parameter list = > A function parameter is not valid, for example, a text instead of a number or a domain reference instead of a cell reference.

    
18.08.2017 / 01:15