Mine was an array formula, so enter with Ctrl-Shift-Enter, not just enter.

It is text, that is why SUM is failing.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"doofy" wrote in message
...
doofy wrote:
Bob Phillips wrote:
Try this array formula

=SUM(--D2:D6)


comes back with #VALUE!


This worked:

=d2+d3+d4+d5+d6


Odd.