Countif fomula to count blank rows

Need to know what type of data is entered into the cells.

Create a dynamic named range.

Name: Range (or whatever you want to name it)
Refers to: =$V$2:INDEX($V$2:$V$1000,MATCH(1E100,$V$2:$V$1000))

Adjust for a reasonable end of range where I use down to row 1000.

Then your formula would be:

=COUNTIF(Range,"")

If this was your data, using the dynamic range, this formula entered in X2:

=COUNTIF(Range,"")

Data Range

	V	W	X
1	Data		Count
2	68		6
3	64
4
5	37
6
7	1
8	86
9
10	20
11	84
12
13
14
15	48
16	------	------	------