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")))

 

[Pecoflyer]

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


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

You can try Ctrl+
replace "Kabul" ( no quotes
with "something_else

Change the options to look in -Formulas
Then click -replace all

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[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