Change cell reference in formula

  • Thread starter Thread starter GTS
  • Start date Start date
G

GTS

Hello,
i have certain formulae of the type:
=SUMPRODUCT((TOTAL!$A$1:$A$150="BTS")*(TOTAL!$B$1:$B$150="A")*(LEFT(TOTAL!$R$1:$R$150;3)="A.T"))

I would like to change the cell reference to 1 to 1000 (instead of 150
and i'd rather not do it by hand everywhere....is there a way t
replace all 150's to 1000?

Thanks in advance,
Georg
 
Hi
you may use 'Edit - Replace' for this. Search
within 'Formulas' and change '$150' to '$1000'
 
I just did it myself! It was so easy after all, stupid me....
Thanks very much anyway!
 
You must log in or register to reply here.

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

Similar Threads

help with changing sumif to sumproduct 2
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Reference Cell Altering Formulas 1
trying to retrieve a cell from table in sheet 2 to sheet 1 1
hlookup with the sheet name is a reference from another cell 2
Solving two equations with known exponent 5
Referencing the closest filled in cell 3
Formula Assistance 3

Back
Top