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.