Adding ranges with "" and numbers

[alkarkar]

I have 10 worksheets from wich i want to add the range A2:W900 (10 times this range, one from each worksheet). Every cell in the ranges has formulas with : 'IF(...=..., "" , ...3...) , so every cell has "" or a number . I want to add this ranges-cells but i get #value! ( adding number+text?).I use copy-paste .Maby a macro with special paste will do my job? I can't figure it out. Help!
Alex

 

[Aladin Akyurek]

I have 10 worksheets from wich i want to add the range A2:W900 (10 times this range, one from each worksheet). Every cell in the ranges has formulas with : 'IF(...=..., "" , ...3...) , so every cell has "" or a number . I want to add this ranges-cells but i get #value! ( adding number+text?).I use copy-paste .Maby a macro with special paste will do my job? I can't figure it out. Help!
Alex

=SUM(Sheet1:Sheet10!A2:W900)

 

[alkarkar]

Sorry , i wasn't clear enough.
I want in another worksheet (sheet final) to add in cell A2 the values of every A2 cells from the other sheets. The formula would be : Sheet1!A2+Sheet2!A2+Sheet3!A2+...Sheet10!A2. In B2 the result of adding sheet1!B2+sheet2B2+....... The same goes down to W900. As i test it now the SUM formula works (SUM(sheet1!A2,sheet2!A2...)) but i have to add it in many cells and my file is allready VERY large. Can i do the same recording a macro?

 

[alkarkar]

I think your idea is good enough. I will record a macro in wich i will add in cell sheetfinal!A2 the formula : SUM(sheet1!A2,sheet2!A2,....sheet10!A2) and copy it down to W900. I guess this will do my job. Thanks ALADIN