"Dave Peterson" wrote in message
...
=sum() ignores cells with text in them:

A1: ASDF
A2: 3

=sum(a1:a2) will return 3
=sum(a1+a2) will return a #value! error
(because a1+a2 will return a #value! error)

Many thanks to everyone for your kind help - I appreciate it.

Ted