Hello,
I'm having a slight problem. I've added daily data (from 2015-2018) for the VIX to a working spreadsheet (attached). When I try to drag the formula I had previously used for dates (2006-2014) that worked in column D, I now get a #DIV/0 error for the new data. Can someone help me please?
Thanks for your help.
Threeputt
your ranges don't go down to the 2015 dates. but if you want a simple fix put =IFERROR((your formulas),"") otherwise I'd try to extend your formula ranges (daterange and closevalues).
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sam is right, your named ranges don't extend all the way to the end of your data.
Also, you might try averageifs instead of sumproducts.
And using iferror to hide the error
=IFERROR(ROUND(AVERAGEIFS(CloseValues,daterange,">="&D2-DAY(D2)+1,daterange,"<="&EOMONTH(D2,0)),2),"")
Thank you both for the help, I changed the ranges.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks