count blank cells in one column based on date in different column

**IreneADS** · 01-15-2014, 05:41 PM

Hi!

I have dates in column I
I have dates in column J

I want to count how many blanks are in column J when the dates in column I are before and including today

Thanks!

**alvin-chung** · 01-16-2014, 05:36 AM

Hi IreneADS, try this.

Formula:

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

**Ace_XL** · 01-16-2014, 06:07 AM

Use

=COUNTIFS(I:I,"<="&TODAY(),J:J,"")

**IreneADS** · 01-16-2014, 09:58 AM

Thank you! Works perfectly!

count blank cells in one column based on date in different column

LinkBack

Thread Tools

Rate This Thread

Display

count blank cells in one column based on date in different column

Re: count blank cells in one column based on date in different column

Re: count blank cells in one column based on date in different column

Re: count blank cells in one column based on date in different column

Thread Information

Users Browsing this Thread

Similar Threads

count filled cells in one column based on date in another column

Forumla to count blank cells in a column when another column in the same row is not blank.

[SOLVED] count the number of populated cells in column N based on data in column D

Excel 2007 : Count blank cells in one column that also meet a date condition in another column

Count cells based on date range in another column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions