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'
 
Back
Top