!?
"Dave Peterson" wrote:
There are some functions that don't work with closed workbooks. =sumif() (in
English) is one of those.
But you could use a different function (=sumproduct() in English):
=sumproduct(--('U:\[TESTE_VINCULOS.XLS]Plan1'!$A2:$A5000=A3),
'U:\[TESTE_VINCULOS.XLS]Plan1'!$B2:$B5000)
(all one cell.)
You'll have to translate the function and change the comma to a semicolon.
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?
--
Dave Peterson
|