+ Reply to Thread
Results 1 to 3 of 3

Count number of blank cells in a column next to date column

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    London, UK
    MS-Off Ver
    2016
    Posts
    54

    Count number of blank cells in a column next to date column

    Hi All,

    I have a column with weekly dates up to Jan 2019.
    The next column is payments made with some missing.
    I would like a formula where it would give me a count of missing payments up to now (Today()?) instead of the entire column.

    I'm sure it's very simple for you experts, so please help!

    Thanks in advance.

    Al

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Count number of blank cells in a column next to date column

    .
    Please Login or Register  to view this content.

    Or, using this formula does the same thing

    =COUNTBLANK(A1:A20)

  3. #3
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Count number of blank cells in a column next to date column

    Hi,

    You mean something like this?

    Excel 2016 (Windows) 64 bit
    A
    B
    C
    D
    E
    1
    6/17/2018
    100
    Missing
    3
    2
    6/24/2018
    3
    7/1/2018
    100
    4
    7/8/2018
    100
    5
    7/15/2018
    6
    7/22/2018
    100
    7
    7/29/2018
    100
    8
    8/5/2018
    9
    8/12/2018
    100
    10
    8/19/2018
    11
    8/26/2018
    12
    9/2/2018
    13
    9/9/2018
    14
    9/16/2018
    15
    9/23/2018
    16
    9/30/2018
    Sheet: Sheet29

    Excel 2016 (Windows) 64 bit
    E
    1
    =COUNTIFS(A1:A16,"<="&TODAY(),B1:B16,"")
    Sheet: Sheet29

    Change cell references/range to match your data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 08-02-2018, 12:06 PM
  2. [SOLVED] Count varying number of blank cells between two values in a column
    By guest2013 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-19-2017, 05:19 PM
  3. Count number of consecutive non blank cells in a column macro excel
    By nasim12w in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-03-2015, 06:00 AM
  4. [SOLVED] count blank cells in one column based on date in different column
    By IreneADS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2014, 09:58 AM
  5. Count number of cells in column per month, ignore blank cells
    By lamdl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2014, 08:50 PM
  6. [SOLVED] Formula to count number of blank cells for a specific condition in another column
    By Daniel_12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-30-2013, 07:16 AM
  7. Replies: 5
    Last Post: 08-05-2009, 02:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1