Hi. I am hoping to get some help with an error I keep receiving in Excel 2013 and Excel 2010. I am going to try to explain it really clearly and tell the steps I have taken:

1) I have a workbook with 3 sheets: Data, Budget and All.

2) The Data sheet has a column called expense which is populated by a formula that grabs data from the All sheet. This is the exact formula:
=INDEX(ALL!$G$2:$G$894,MATCH(O3,ALL!$F$2:$F$894,FALSE),1)

3) I have entered the following formula in the Budget sheet which should Sum the expense column from the Data sheet: =Sum('Data'!k2:k84)

4) Instead of returning the Sum of the column it returns #N/A.

Any thoughts? This is making me go crazy. I know I have summed cells and columns with formulas in them before.