Change the ranges formulas refer to

[Green1972]

Hi Ive been of excel for a while and have forgotten what to do so please help.

I have the formulas listed below and have hade to change the range they refer to. When I enter t=it and hit return the answer in the cell is wrong.

=MAX(IF('Draw Results'!C1:C2283={0.3,4},'Draw Results'!A1:A2283))
=MAX(IF('Draw Results'!C1:C2248={3,4},'Draw Results'!D1:D2283))

It worked fine before I increased the range (C2241 up to C2283 and A or D2241 upto A or D2283)
Please help.

 

[Green1972]

Re: Help

Is it possible that I have somehow Maxed the sheet/ document size? I am a none commercial user and the file size is 13089kb.

 

[mrhstn]

Re: Help

I think that is going to depend on your system resources, have a look at the specifications and limitations

Excel specifications and limits - Excel

Close down Excel, then open up a brand new workbook with nothing else open, enter into cell A1 the formula

=1

And confirm with ctrl+shift+enter

Does this formula end up with {} curly braces round it?

 

[Green1972]

Re: Help

So ive been looking at the sheet and it would seem that any formula that involves sells beyond 2248 is having the same problem. is there any way I can sort this? any suggestion or help or should I just forget the whole thing as I am really stumped.