Counting Rows in Excel

[Ray -13]

Hi
I need to count every alternate rows that contain data in a column.

 

[J.E. McGimpsey]

Take a look at one potential solution in excel.newusers.

 

[Alan Beban]

For anyone to whose workbook the functions in the file at
http://home.pacbell.net/beban are available:

=COUNTA(ArrayAlternates(A1:A1000)) for odd rows,

=COUNTA(ArrayAlternates(A1:A1000,FALSE)) for even rows

Alan Beban