SUMIF is not update why?

[vlook fomula]

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

 

[Satyendra_Haldaur]

My experience says it is better if you click on dont update.it would not
create any hazardous on the connectivity within your files.

 

[Satyendra_Haldaur]

My experience says it is better if you click on dont update.it would not
create any hazardous on the connectivity within your files.

 

[Dave Peterson]

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.

 

[Dave Peterson]

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.

 

[Sean Timmons]

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!

 

[Sean Timmons]

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!