View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Counting in a variable range

Hi and thank you in advance.

I'm trying to count the word "Standard" in a series of ranges. Say A10-A15,
then maybe A40-A43...it keeps changing from 3 rows upto 10 rows.

Is there anyway to count in a range when the range keeps changing in the
amount of rows. Like it won't ever be only 5 rows, it may be 3 rows, 6 rows,
9 rows and then 2 rows.

Any help is greatly appreciated.

Thank you again.

Tim