Error #value in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
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?
Click to expand...
 
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
 
Change that to

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


Regards,

peo Sjoblom

Peo Sjoblom said:
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 said:
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?
Click to expand...
Click to expand...
 
!?

Dave Peterson said:
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.
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?
Click to expand...
Click to expand...
 
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 said:
!?
Click to expand...
<<snipped>>
 
Back
Top