Error #value in excel

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?

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

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?

Change that to

=SOMARPRODUTO(--('U:\[TESTE_VINCULOS.XLS]Plan1'!$A2:$A5000=A3);'U:\[TESTE_VINCULOS.XLS]Plan1'!$B2:$B5000)


Regards,

peo Sjoblom

"Peo Sjoblom" wrote:

> 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?

!?

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

But I still don't recognize the language.

Something to do cigars--no wait, that's el Producto.

And why should a good Swede like you be such a polyglot?


Peo Sjoblom wrote:
>
> !?
>
<<snipped>>