Here is the formula I'm working with:
It works perfectly except when it comes to end of the rows of data and encounters blank cells, it then spits out the dreaded "#N/A" error. Since the data slowly fills as the year goes on, I cannot simply limit the cells it calculates.
How can I change the formula to not freak-out when encountering blank cells?
Thanks in advance.