The sum function is tailor made for this request.
=sum(a1:a3)

--
Kevin Vaughn


"LLM" wrote:

Hello,

I am a novice excel user and I am trying to sum cells, some of which
have numbers and text, others that have only numbers. I have to add,
for example: 0.2U, 0.3, 0.1U. Or 0.4U, 0.5U. I need to add only the
cells that do not contain text. The first example should return a sum
of 0.3, the second should return 0. Any suggestions?
LLM