Thanks a million, Charlie!! It worked! Do you have a link that explains how and why this works? That way, I'll know how to apply it to other situations. I don't recall seeing many of those characters in any of the other formulas I tried while researching this. Maybe that's why none of them worked.

This works perfectly, because when '0' is entered, I want it to do that calculation (which it does!) and it ignores the blank cells (which it should!).
How does it know to differentiate between 'blank' and zero?