I have a formula that sums the the products of two columns, A & B. Sometimes
I need to put a word in these cells instead of numbers and it renders the sum
invalid. Is there a way to get the formula to ignore it when there is text
in the cells?

Thanks!!!

Steve