#### jmiaebrown

##### Board Regular

- Joined
- Jul 13, 2008

- Messages
- 129

I have defined a dynamic range name TCMStartRow as

=OFFSET('Test Case Matrix'!$A$7,0,0,COUNTA('Test Case Matrix'!$A:$A),1

The row header is on $A$7 and the end is unknown. On another sheet I defined a formula to count the number of columns with text equal to another column

=COUNTIF(TCMStartRow,$A10)

So if $A10="Module1" within the TCMStartRow dynamic range then we should count it.

This seems to work somewhat but it does not seem to extend all the way down the column. I think maybe because of the empty cells that I have in ColumnA.

Have I defined the dynamic range incorrectly?

R/C | A | B | C | D | E | F | G |

52 | Module1 | 1 | Do Test Case1 | 1 | Do Step1 | ||

53 | 2 | Do Step2 | |||||

54 | 3 | Do Step3 | |||||

55 | Module1 | 2 | Do Test Case2 | 1 | Do Step1 | ||

56 | 2 | Do Step2 | |||||

57 | 3 | Do Step3 | |||||

58 | Module2 | 1 | Do Step1 | ||||

59 | 3 | Do Test Case3 |