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.

On 21/10/2011 20:23, carl wrote:
=(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

On Oct 21, 2:23*pm, carl wrote:
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);--
(colg="SailErrorNotice");cola))