More info: When I click on the "!" to find out about the error, it says "formula referrs to empty cells." Well so does D47 (formula there is the same: =sum(D2:D46) , and that works fine! Also, if I place =sum(C2:C46) anywhere in column A instead of C, then it returns the sum correctly. Any thoughts on solutions?