Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a SUM function...
"mitov" wrote in
message ... 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! =SUM(B4:B65536) You could also use =SUM(B:B)-SUM(B1:B3) but if you are putting the total at the top of the column you are calculating, this would give a circular reference. -- David Biddulph |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a SUM function...
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 __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |