J
Juan Sanchez
ADOT
I don't know if this has something to do with the problem,
but it might solve it... what you are doing with an array
formula is the same as this:
=SUMPRODUCT(--(CC_date>=DATE(2004,1,1)),--(CC_date<DATE
(2004,2,1)),CC_amount)
I am assuming that your linked formula does looks
something like this:
=SUM(('C:\original.xls'!C_date>=DATE(2004,1,1)...
this is not an array formula, just ENTER...
to the first document and references arrays in the first
document. The result of the formula in the document that
contains the ranges that are referenced is calculated
correctly. The result of the same formula in the linked
document is 0. Does anyone know of a reason for this and
is there a solution?
I don't know if this has something to do with the problem,
but it might solve it... what you are doing with an array
formula is the same as this:
=SUMPRODUCT(--(CC_date>=DATE(2004,1,1)),--(CC_date<DATE
(2004,2,1)),CC_amount)
I am assuming that your linked formula does looks
something like this:
=SUM(('C:\original.xls'!C_date>=DATE(2004,1,1)...
this is not an array formula, just ENTER...
references local arrays and one in a document that links
to the first document and references arrays in the first
document. The result of the formula in the document that
contains the ranges that are referenced is calculated
correctly. The result of the same formula in the linked
document is 0. Does anyone know of a reason for this and
is there a solution?