View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mitov mitov is offline
external usenet poster
 
Posts: 1
Default Help with a SUM function...


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!


--
mitov
------------------------------------------------------------------------
mitov's Profile: http://www.excelforum.com/member.php...o&userid=36194
View this thread: http://www.excelforum.com/showthread...hreadid=559838