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.

1

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*:

```
=SUM(IF(ISNUMBER(A:A),A:A))
```

should work.

**Array formulas** must be entered with `Ctrl` + `Shift` + `Enter` rather than just the `Enter` key.

How to Askto improve your question. – CharlieRB Apr 27 '15 at 13:32