Excel 2010 Summing Function Error


Ive got an excel file with a lot of line items and cant get a subtotal or sum at the bottom of some columns, instead I get #Value!.
Googled this to find a statement that this happens with a 3D reference.
Not sure if this is true and if I have a 3D reference.  Nonetheless there are no suggestions how to resolve.
Hope someone can help find smart solution.
Who is Participating?
Alex WuCommented:
There is an invalid data type in your spreadsheet. The data in line 8064 is causes errors in propagating formulas. Fixing that line seems to fix the errors regarding #Value!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.