Global Change Of Formula Value

[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.

 

[David Biddulph]

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

Find and replace.

David Biddulph

 

[Don Guillett]

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.

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);--