LinkBack URL
About LinkBacks
Does anyone know the formula or macro to count the cell totals of groups of connecting cells in a column and ignoring blank cells between these groups of cells.
If searched but can't find it anywhere so far.
Thank you and greetings from Mirtje
count the cell totals of groups
Does anyone know the formula or macro to count the cell totals of groups of connecting cells in a column and ignoring blank cells between these groups of cells.
If searched but can't find it anywhere so far.
Thank you and greetings from Mirtje
Last edited by mirtjemirtej; 09-10-2009 at 09:52 AM.
Based on your example worksheet:
in cell B24: =COUNT(B2:B4)
in cell B25: =COUNT(B7:B8)
Continue the formula, adjusted for range of values to count.
Originally Posted by Palmetto
Hi Palmetto,
Thank you for your help, but it's not that simple.
The formula has got to go through the whole column and through only one celgroup.
Still not very clear, do you mean something like:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hello DonkeyOte,
Yes absolutely, that's it!
Thank your very much.
If I want to let the macro automaticly go through a next column for instance column F how do that.
Can you please give me the code extension for that?
Thanks again!
Perhaps you mean
Please Login or Register to view this content.
Re: count the cell totals of groups
Hello again DonkeyOte,
Thanks for helping me out!
Greetings from The Netherlands
Last edited by DonkeyOte; 09-10-2009 at 09:52 AM. Reason: removed (unnecessary) quote
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks