Countif fomula to count blank rows

What type of data is it? Is it text? Numbers? Could be both? Something else?

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	------	------	------