# Count blank rows

#### lapta301

##### Well-known Member
I have data in column E with no blank entries from E4 to currently E224.
When the job in hand has been done I enter a date in column D.

I would like a formula in D 250 which would find the last row in column E with data in it currently E224 and then count the number of rows in column D that are blank.

I hope this makes sense and as ever your help is appreciated.

EDIT: I should add that the position of the formula will move down as records are added

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### Fluff

##### MrExcel MVP, Moderator
Excel Formula:
``=LOOKUP(2,1/(E4:E249<>""),ROW(E4:E249))-LOOKUP(2,1/(D4:D249<>""),ROW(D4:D249))``

#### lapta301

##### Well-known Member
Thank you for your response however it doesn’t appear to be finding any blank rows in column D

#### Fluff

##### MrExcel MVP, Moderator
I think I may have miss-understood, are you trying to find the number of blanks in col D below the last date, or the total number of blanks?

#### Habtest

##### Board Regular

Is it correct that you'd like the total of rows above 250 where column E is filled but column D is not? Then
Excel Formula:
``=SUM(--ISBLANK(FILTER(D2:D249,LEN(E2:E249)>0)))``

#### Fluff

##### MrExcel MVP, Moderator
Another option for total blanks in D
Excel Formula:
``=COUNTIFS(E\$4:E249,"<>",D\$4:D249,"")``

#### lapta301

##### Well-known Member

I think the latest version will work (but what do I know) but the system I’m on at the moment hasn’t been upgraded so I‘ll give it a go on my home machine shortly and report back.
Again sincere thanks for taking the time

#### lapta301

##### Well-known Member
Fluff I’m sorry I didn’t realise that there was a new member helping me.
However im pleased to say that they both work fine.

So Fluff and Habest my sincere thanks to you both for taking the time to help me

#### Fluff

##### MrExcel MVP, Moderator
Glad we could help & thanks for the feedback.

Replies
3
Views
156
Replies
4
Views
28
Replies
3
Views
77
Replies
11
Views
351
Replies
3
Views
190

1,136,786
Messages
5,677,724
Members
419,715
Latest member
Daniellovesxl

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back