When I run evaluate on some of the cells having #value, the error that is occurring is that you are trying to add values to cells that are blank. You might be better off converting the blank cells to zero and see if that works for you. To test: Highlight the cell in question. On the Formula Tab, click on Formula Auditing and Evaluate. It will show where the errors are occurring at you tab through the formula