Dave, It worked perfectly. Thank you very much.
Richard

"Dave Peterson" wrote:

How about:

=SUM(IF(ISNUMBER(A1:A100),A1:A100))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Change the range, but not to the whole column.

Tucson Guy wrote:

"Tucson Guy" wrote:

Thanks for trying Frank, but it came up with "Value" error message.
Any other thoughts? Thanks

--

Dave Peterson