Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In that case, why not =SUM(B:B)-SUM(B1:B2) ?
-- David Biddulph MrNobody wrote: The only problem is this seems to sum the entire column. I need it to start summing at B3 down to whatever is left, because on the first two rows are numbers I don't want included in the summing. Any way to do that? Thanks! "Pete_UK" wrote: You could just do: =SUM(B:B) as long as the formula is not in column B - it will ignore blanks and text. Hope this helps. Pete On Feb 20, 1:02 am, MrNobody wrote: I have a column of numbers starting at cell B3. The number of rows is not fixed - it changes. How do I write one SUM function to sum everything from B3 to the last number, whatever row it might be on? Is there a way to combine it with the COUNT function to accomplish this goal? Please show me an example |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a subtotal for an indeterminate number of rows | Excel Discussion (Misc queries) | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
indeterminate 0/0 | Excel Discussion (Misc queries) | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |