Global Change Of Formula Value

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I have several formulas in a spreadsheet. For example this one...

=(SUMPRODUCT(--($E$42:$E$22956=549);--(LEFT($C$42:$C$22956;2)=C$5);--
($G$42:$G$22956="SailErrorNotice");$A$42:$A$22956))

Is there a way to change the range from 22956 to 30000 ?

I am trying not to have to go into each formula and make this change.

Thanks.
 
=(SUMPRODUCT(--($E$42:$E$22956=549);--(LEFT($C$42:$C$22956;2)=C$5);--
($G$42:$G$22956="SailErrorNotice");$A$42:$A$22956))
Click to expand...

Find and replace.

David Biddulph
 
I have several formulas in a spreadsheet. For example this one...

=(SUMPRODUCT(--($E$42:$E$22956=549);--(LEFT($C$42:$C$22956;2)=C$5);--
($G$42:$G$22956="SailErrorNotice");$A$42:$A$22956))

Is there a way to change the range from 22956 to 30000 ?

I am trying not to have to go into each formula and make this change.

Thanks.
Click to expand...

Or you could just have defined names for your ranges and forget about
it henceforth
colA =offset($a$41,1,0,0,counta($a:$a)-41,1)
colC =offset(cola,0,2)
colC =offset(cola,0,2)
cole =offset(cola,0,5)
=(SUMPRODUCT(--(cole=549);--(LEFT(colc,2)=C$5);--
 
Back
Top