Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
!?
"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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |