Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 17th 06, 01:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 8
Default 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.

  #4   Report Post  
Old November 17th 06, 03:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting cells with blank adjacent cell Wingman Excel Worksheet Functions 4 November 16th 06 09:39 PM
Calculating only non-empty cells... Jay Excel Worksheet Functions 9 September 22nd 06 03:20 AM
Sumif Cells Are Not Blank Powlaz Excel Worksheet Functions 12 March 15th 06 04:40 PM
Counting blank and filled cells within a range. greg7468 Excel Discussion (Misc queries) 3 June 28th 05 10:41 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017