SOMASE or SUMIF in English does not work when the workbooks are closed, you
can use SUMPRODUCT instead (SOMARPRODUTO) then use it as
=SOMARPRODUTO(--('U:\[TESTE_VINCULOS.XLS]Plan1'!$A2:$A5000=A3);--('U:\[TESTE_VINCULOS.XLS]Plan1'!$B2:$B5000))
HTH
Peo Sjoblom
"Ferdina" wrote:
Hi,
I have a problem with links in excel, i´m using this expression:
SOMASE('U:\[TESTE_VINCULOS.XLS]Plan1'!$A2:$A5000;A3;'U:\[TESTE_VINCULOS.XLS]Plan1'!$B2:$B5000).
this link path above exists.
What happen?
|