bydesign
Board Regular
- Joined
- Nov 29, 2003
- Messages
- 184
All
In Excel 97 & 2003, I have been using dynamic ranges to count the total number of cells with data in a column using =OFFSET(SF!$G$2,0,0,COUNTA(SF!$G:$G)-1). This has always worked well.
In Excel 2007, using the same formula; I am getting a return of the value in G9... not the total number of cells with data in column G.
Column G has a title row and 137 contiguous cells with data.
When I edit the formula by opening the "Function Arguments" window (e.g. click "fx") the proper value of 136 is displayed next to the "height" argument.
Any ideas?
In Excel 97 & 2003, I have been using dynamic ranges to count the total number of cells with data in a column using =OFFSET(SF!$G$2,0,0,COUNTA(SF!$G:$G)-1). This has always worked well.
In Excel 2007, using the same formula; I am getting a return of the value in G9... not the total number of cells with data in column G.
Column G has a title row and 137 contiguous cells with data.
When I edit the formula by opening the "Function Arguments" window (e.g. click "fx") the proper value of 136 is displayed next to the "height" argument.
Any ideas?