XMIRR Help

[mayday1028]

Attention Finance gurus - XMIRR Struggles

I need some help with the XMIRR function. Jay Petrulis has referenced the link below several times as a way to combine the best of the MIRR and the XIRR functions. However, when I apply it to a list of about 120 cash flows (several positive and several negative), I get a #VALUE error. BUT, when I do the F2 and F9 to see the result, the interest rate is right in the neighborhood of what I was expecting. Any ideas why I might be getting this error? I have posted the formula below where the dates are in cells b6:b128 and the values are in cells e6:e128. Thanks!
=POWER((SUM(IF(E6:E128>0,E6:E128*(POWER(1+0.05,(MAX(B6:B128)-B6:B128)/365)),0)))/(SUM(IF(E6:E128<0,E6:E128/(POWER(1+0.05,(MAX(B6:B128)-B6:B128)/365)),0)))*-1,1/((MAX(B6:B128)-MIN(B6:B128))/365))-1


BELOW is one of the posts from Jay Petrulis that I referred to above:
If you can assign dates to the flows, you can get a better option: XMIRR, a
custom function created by David Hager, found here...

http://j-walk.com/ss/excel/eee/eee017.txt

It may give an annualized result, as XIRR does, which can easily be adjusted.

 

[sbolour4]

I was looking to understand the same concept. Before finding this website I created an example of my own....you can find my explanation below

http://www.linkedin.com/groups/xIRR-MIRR-xMIRR-44008.S.90235800