Thanks
I was resigned to writing a macro or manually using
replace to change the operator when needed. This tip will
be very helpful either way.

-----Original Message-----
How about adding a unique pattern of spaces to the
operator in the
formula and then doing a Replace?
Example: (^ are spaces)
=Sumproduct((Range1^=^Criteria1)*(Range2^^^Crite ria2)*
(Range3^^^<^Criteria3))
This prevents the same operators in different locations
from being
changed.

.