counter

[JasonLeVan]

I need a formula that will count how many rows in column a have data in them

 

[MrKowz]

Try the COUNTA function: =COUNTA(A:A)

However, if column A is full of formulas that could return a blank, this formula will not work. Instead, you may want to use =COUNTIF(A:A,"<>")

 

[Trevor G]

Use counta formula

Excel Workbook
	D
4	a
5	a
6	a
7	a
8	a
9	1
10	1
11	1
12
13	8
Sheet1

 

[Jose_Chasez]

=COUNTA(A:A) will count the number of cells in column A that contain data