How do I find & replace pieces of a formula?

[Marty]

I have created a simple formula but its long. How do I edit (find & replace)
pieces of the formula. For example, my formula is
=sum(e3*e5)+(f3*f5)+(g3*g5)+....., I want to do a find on 3 and replace it
with another number. Can that be done and if yes, how.
Another way of looking at the formula is - row 3 has different prices for
columns e thru bba. Rows 5 thru 225 have a number of items. I need to
multiply the prices by the items for each row/column and get a total for each
row. The prices are constant and always in row 3 while the items go from row
5 thru 225.
I hope that someone understands what I am trying to do and can help me.

 

[Peo Sjoblom]

Works fine for me, btw you can simplify the formula


=SUM(E4*E5,F4*F5,G4*G5)


I replace the 3 with 4 and worked fine. Just select the formula(s) and do
ctrl + h and put 3 in find what and 5 in replace with

--


Regards,


Peo Sjoblom

 

[Glenn]

Works fine for me, btw you can simplify the formula


=SUM(E4*E5,F4*F5,G4*G5)

or

=SUMPRODUCT(E4:G4,E5:G5)


I replace the 3 with 4 and worked fine. Just select the formula(s) and do
ctrl + h and put 3 in find what and 5 in replace with

 

[Pete_UK]

Hi Peo,

not seen you posting for a while. Welcome back.

Pete

 

[Marty]

Hi, my problem is that the find finds the number in the data portion of the
spreadsheet and NOT in the formula. How do I get to the formula to edit it?

 

[David Biddulph]

Your first step can be to remove the unnecessary SUM function. You've
calculated E3*E5 and then called the SUM function but not told it what you
want added to E3*E5.
=sum(e3*e5) is just =e3*e5