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.

## Bookmarks