sum whole column from another sheet into cell

[xzerox]

Hello!
I want to sum whole column into another sheet cell.
Example. I want in cell A1 (sheet1) sum all from B2 till Bxx (or B500 if is easier)(sheet2). Any help?

 

[MrKowz]

Try:

=SUM(Sheet2!B2:B500)

Or if you are looking to sum from B2 until the last numerical entry in column B:

=SUM(Sheet2!B2:INDEX(Sheet2!B:B,MATCH(9.99E+307,B:B)))

 

[xzerox]

First formula looks fine but he ask me to update values from some file (?)

 

[MrKowz]

First formula looks fine but he ask me to update values from some file (?)

eh?

 

[xzerox]

now working good :D dunno what happen'. Thank you!