prolly simple...
how would i write a formula to always only do calculations for the last 50 numbers entered into a column, ei. =SUM(last 50 cells in column A) etc, while i'm always adding new data to the list and i want calculations only to those last 50 cells?

thanks, i hope you know what i mean.