Use ISNUMBER():

In place of A1 use =IF(ISNUMBER(A1),A1,"")
--
Gary''s Student


"Russellrupert" wrote:

If text is input into some cells referenced by a formula I want the formula
to ignore whatever text it finds and just calculate the result of the numbers
in cells. How do i do this?
Presently the formula displays #VALUE! where there is text in one or more of
the cells referenced.