changing formulas

[ISAF Media Analysis]

I'm working with many formulas like the one below, and would like to know if
there is any way of using a "find" and "replace all" function for a formula.
Such as if I wanted to change all the Kabul's to Chicago for example. Or
will I have to do it manually.


=SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="NEG")*(S4:S99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="NEG")*(T4:T99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(H4:H99="NEG")*(U4:U99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(J4:J99="NEG")*(V4:V99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(J4:J99="NEG")*(W4:W99="SE
1.1")))+SUMPRODUCT(((E4:E99="Kabul")*(J4:J99="NEG")*(X4:X99="SE 1.1")))

 

[Teethless mama]

Use cell reference instead of hardcode in the formula.

E1: holds Kabul
H1: holds NEG
S1: holds SE 1.1


=SUMPRODUCT((E4:E99=E1)*(H4:H99=H1)*(S4:X99=S1))

 

[Don Guillett]

=SUMPRODUCT(((E4:E99="Kabul")*((H4:H99="NEG")+(J4:J99="neg"))*(S4:X99="SE>
1.1")))
& substitute as below