SumProduct, if used as its native syntax requires, would ignore text
values in the range to sum. Perhaps you would want to elaborate on what
you want to calculate.
T.R. wrote:
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.
|