I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting values but received the same error.
With regard to limits on the SUM() function, I filled ALL of column A with the value 20 and
=sum(A:A) calculated properly.
If there are any errors in column A or text values, then the array formula:
Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key.