Applying INDIRECT function for Covariance calculus

[geri_n]

Hi all,
I have the following problem. I have to calculate covariance of two arrays and I use the "COVAR" function fot this. But I would like to change arrays by changing starting and ending dates. I suppose I have to insert "INDIRECT" to extract data from dynamic range but I cannot do it. I will appreciate if you can help me. I enclose an example file.

Regards

[NBVC]

Try:

Please Login or Register  to view this content.

[sweep]

Hi,

In your example, you have A24 and A25 as start and end dates. The following formula returns the result of the COVAR function between those dates.

Please Login or Register  to view this content.

[geri_n]

Thanks a lot. It work. Now I will try to make thread "Solved".