OK... I'm still having memory problems...
I have a 13 thousand row table that I need to link to a summary worksheet- my formulas are countif's and sumif's
EG-
=SUMIF('really big sheet F:$F,1, really big sheet$Q:$Q) F being decile and Q being in this case savings
So this formula adds all the decile 1 savings in the 13 thousand row spreadsheet. I do this for deciles 1 to 10 for about 15 variables.
Well I'd like to do it- I get a 'not enough memory to update links" message and a #VALUE value.
Any ideas on how I can get this to work?
I have a 13 thousand row table that I need to link to a summary worksheet- my formulas are countif's and sumif's
EG-
=SUMIF('really big sheet F:$F,1, really big sheet$Q:$Q) F being decile and Q being in this case savings
So this formula adds all the decile 1 savings in the 13 thousand row spreadsheet. I do this for deciles 1 to 10 for about 15 variables.
Well I'd like to do it- I get a 'not enough memory to update links" message and a #VALUE value.
Any ideas on how I can get this to work?