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 |
All times are GMT +1. The time now is 08:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com