Counting Non blank Cells that fall between cells with conditions

[USChad]

I attached a spreadsheet in case i do not do a good job of explaining. This may not be possible with a formula. I would like a formula to look in a certain column and when it finds text like in the spreadsheet "EXAMPLE 1" it counts all of the non blank beneath it until it either gets to a blank spot or the next "EXAMPLE X".


Thanks in advance.

[DonkeyOte]

Based on the sample file:

F2: =COUNTA(B4:INDEX(B:B,MATCH(REPT("Z",255),B:B)-1))

[contaminated]

DonkeyOte
I tried your formula, but I don't know why I got wrong results. Take a look at this book.

Instead of your formula I used

Please Login or Register  to view this content.

in G12.

[DonkeyOte]

Vusal, correct, per my note it was based on the sample file (ie two records).

If you wanted to go down the route of using helpers as you have in A (which incidentally I concur is definitely the way to go) I think by adapting the formulae you use in A you can make all subsequent calcs a great deal simpler (and non-volatile), ie (based on your file):

clear A1 & A2
A3: =(ABS($E2)+(LEFT($C3,7)="EXAMPLE"))*(1-2*($C3=""))
copied down for all rows

Then

H12: =COUNTIF($A:$A,-1*INDEX($A:$A,MATCH($F12,$C:$C,0)))
copied down for other examples