On Mon, 10 Jul 2006 07:04:09 -0400, mitov
wrote:


Hi everyone,

I need some help with a SUM function. Basicaly, in my spreadsheet, the
first couple of rows have numbers and letters in them.

The problem is that i need every column to have a total, which is also
located at the top.

Is is possible to get a SUM functions which, for exampls adds up column
B from cell B4 to infinity? What i mean is that the end range is
basicaly infinity, as i dont know how many rows down i will go.

If this is not possible, is it possible to get a SUM of column B, but
somehow make it exclude the first 3 rows from its sum?

ANY HELP WILL BE GRATEFULLY APPRECIATED! THANK YOU ALL!

Why not just =Sum(B4:B65536) ?

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________