Count Entries until blank cell, then resume counting until next blank

[Makende]

Capture.PNG

Hi Guys,

I need to be able to count the number of entries (z's) in each column, but only count until a blank cell is reached. Then resume counting again till another blank cell is reached.
For example:

z
z
z
z
[blank]
[blank]
z
z

Count=4
Count = 2

Look at the pic for more examples

Any help is appreciated, thanks!

[mehmetcik]

1. Would a Macro work for you


2. Are we only interested in columns C, E and G

3. How would you trigger the Macro?

[GeoffW283]

Here is a formula based solution. It does however need a helper column for each column to be counted.

In D3 then copied down:

Please Login or Register  to view this content.

Same for F3, H3.

In C31 copied down:

Please Login or Register  to view this content.

Copy to E31:E34 and G31:G34

Attached is a workbook implementing the above.

[Bo_Ry]

Please try at C29
=IFERROR(MOD(AGGREGATE(15,6,1/(1/FREQUENCY(IF(C$3:C$26<>"",ROW(C$3:C$26)),IF(C$3:C$26="",ROW(C$3:C$26))))+ROW(C$3:C$26)*10^3,ROWS(C$29:C29)),10^3),"")

Press Ctrl+Shift+Enter drag across and down

[Makende]

Thanks so much!! it worked

[GeoffW283]

Thanks for the feedback and reputation points