View Single Post
  #7   Report Post  
Herbert Seidenberg
 
Posts: n/a
Default

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^^^Criter ia2)*(Range3^^^<^Criteria3))
This prevents the same operators in different locations from being
changed.