If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SUMIF is not update why?
Dear all,
I am facing problem in SUMIF formula and problem is: I have applied SUMIF formula and linked with another file not, when I try to open this file it shows update then I click on it. But it is not updating file and shows #VALUE!, if I open the link file its auto update, while this file has so many “vlook” application also liked with the same file it is not creating problem but SUMIF applications only. Kindly help in this regards God Bless u all Zafar |
#2
|
|||
|
|||
SUMIF is not update why?
My experience says it is better if you click on dont update.it would not create any hazardous on the connectivity within your files. "vlook fomula" wrote: Dear all, I am facing problem in SUMIF formula and problem is: I have applied SUMIF formula and linked with another file not, when I try to open this file it shows update then I click on it. But it is not updating file and shows #VALUE!, if I open the link file its auto update, while this file has so many “vlook” application also liked with the same file it is not creating problem but SUMIF applications only. Kindly help in this regards God Bless u all Zafar |
#3
|
|||
|
|||
SUMIF is not update why?
I'm confused about whether this =sumif() points at another workbook.
If it does, then that workbook has to be open for =sumif() to evaluate correctly. But there are other functions you maybe able to use instead: The array formula: =sum(if(...)) or =sumproduct() If the =sumif() points at ranges in the same workbook, I'd look for #value! errors in the ranges used in that =sumif() function. vlook fomula wrote: Dear all, I am facing problem in SUMIF formula and problem is: I have applied SUMIF formula and linked with another file not, when I try to open this file it shows update then I click on it. But it is not updating file and shows #VALUE!, if I open the link file its auto update, while this file has so many “vlook” application also liked with the same file it is not creating problem but SUMIF applications only. Kindly help in this regards God Bless u all Zafar -- Dave Peterson |
#4
|
|||
|
|||
SUMIF is not update why?
The alternative is to use SUMPRODUCT. It's a bit of an odd workaround, but it
does update when your linked file is closed. If your sumif was, say, =sumif([Book.xls]Sheet!$A:$A,A2,[Book.xls]Sheet!$B:$B) Then, sumproduct would be: =SUMPRODUCT(--([Book.xls]Sheet!$A:$A=A2),[Book.xls]Sheet!$B:$B) somehwat inelegant, but it works! "Satyendra_Haldaur" wrote: My experience says it is better if you click on dont update.it would not create any hazardous on the connectivity within your files. "vlook fomula" wrote: Dear all, I am facing problem in SUMIF formula and problem is: I have applied SUMIF formula and linked with another file not, when I try to open this file it shows update then I click on it. But it is not updating file and shows #VALUE!, if I open the link file its auto update, while this file has so many “vlook” application also liked with the same file it is not creating problem but SUMIF applications only. Kindly help in this regards God Bless u all Zafar |
Thread Tools | |
Display Modes | |
|
|