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.

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


"Marty" wrote in message
...
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 wrote:
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

Hi Peo,

not seen you posting for a while. Welcome back.

Pete

On Sep 11, 9:42*pm, "Peo Sjoblom" wrote:
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

"Marty" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

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?

"Peo Sjoblom" wrote:

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


"Marty" wrote in message
...
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.

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
--
David Biddulph

"Marty" wrote in message
...
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.