Determine Row Count Based on Cell Contents "Annualized"

[blaker]

is there a way to write a formula that counts the number of rows, where the counts starts at offset(2,-1) from cell containing formula, and ends where the word "Annualized" Appears?
any help is much appreciated...
Thanks!!

hopefully this will help..

 

[bobsan42]

if your formula is in K2, servings to count in column J, and keyword "Annualized" in L try this:

=COUNT(OFFSET(J4,2,0,MATCH("Annualized",OFFSET(L4,2,0,999999,1),0)-1,1))

 

[blaker]

I may not of given you enough info, I have attached a screen shot that may explain better, I need a formula that will count the number of rows in each group, the number of rows will vary and and sometimes a row will be deleted and the count need to update with new row count... hopefully the entire screen shot will help...
Thanks so much for the help!!

 

[bobsan42]

Which column do you want counted? S?
My formula is atill what you need just the references must be adjusted. I thougt your formula is in column R, now I see you want it in T.
Use this for the formula in T6:

=COUNT(OFFSET(S6,2,0,MATCH("Annualized",OFFSET(S6,2,0,999999,1),0)-1,1))

 

[blaker]

I want a count of the rows between for the first group where the red cell is 2 this is counting how many rows starting down 2 and to the left 1 that are numbers in green, the end is always the cell with annualized, does this help, not column count row count...

 

[bobsan42]

You want ... ?!
I am pretty sure that's what the formula does.
Do you get a different result using the formula?

 

[blaker]

it gives me 0 it should give in "T6" 2

 

[bobsan42]

Looking at your screenshot I suspect that the green $numbers are not numbers but text.
COUNT only counts numbers.
Replace it with COUNTA.

 

[blaker]

That was it!!!

Thanks a ton!!!

 

[blaker]

Acctually when i pasted it down it only gives me 1 where the counts are 2 , 6 , 5 etc... sorry very close though