How do I find & replace pieces of a formula?

M

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.
 
P

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
 
G

Glenn

Peo said:
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
 
M

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?
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top