Home 
Search 
Today's Posts 
#1




Summing (or counting) cells until there is a blank cell
I want to sum a portion of a column until there is a blank cell. The number
of cells varies too much to use a bunch of nested IF functions. For example, I'd like C100 to be the sum of cells C99 and above until there is a blank cell. The first blank cell (working upward) may be C75 (or C65) and there will be additional values in the cells above the blank cell. How can I do this? Also, it would be helpful if I could count the number of cells until the first blank cell. I can reverse the order, that is sum the cells below a cell until reaching a blank cell, but there will be additional values below the first blank cell. The spreadsheet I'm working on has one day per row and the grouped rows (days) have between 15 and 25 days in each group. The total number of groups is over 200 so summing each individual group takes for ever (I know because I tried that) Thanks for your help. 
#2




Summing (or counting) cells until there is a blank cell

#4




Summing (or counting) cells until there is a blank cell
A macro that finds the blank and sums to the next blank. Involved.
 Don Guillett SalesAid Software "Box815" wrote in message ... I've tried that and I end up with a big mess. Blank rows are inserted, the subtotal is mixed in with groups below the target, etc. Any other guidance on subtotals or other suggestions? Thanks "Don Guillett" wrote: try hightlighting the columndatasubtotals  Don Guillett SalesAid Software "Box815" wrote in message ... I want to sum a portion of a column until there is a blank cell. The number of cells varies too much to use a bunch of nested IF functions. For example, I'd like C100 to be the sum of cells C99 and above until there is a blank cell. The first blank cell (working upward) may be C75 (or C65) and there will be additional values in the cells above the blank cell. How can I do this? Also, it would be helpful if I could count the number of cells until the first blank cell. I can reverse the order, that is sum the cells below a cell until reaching a blank cell, but there will be additional values below the first blank cell. The spreadsheet I'm working on has one day per row and the grouped rows (days) have between 15 and 25 days in each group. The total number of groups is over 200 so summing each individual group takes for ever (I know because I tried that) Thanks for your help. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Counting cells with blank adjacent cell  Excel Worksheet Functions  
Calculating only nonempty cells...  Excel Worksheet Functions  
Sumif Cells Are Not Blank  Excel Worksheet Functions  
Counting blank and filled cells within a range.  Excel Discussion (Misc queries)  
GET.CELL  Excel Worksheet Functions 