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")