I am attempting to use the SUMPRODUCT formula to calc.
numbers in four columns. However, the range contains both
text and number and as a result I get a #Value reference.
Is there another formula that works similiar to the
SUMPRODUCT but will automatically ignore the text and
calc. the numbers only?

Thanks.

T.R.