+ 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
    2007
    Posts
    44

    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
    2007
    Posts
    3,507

    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)
    DEPLORABLE : A hard working, tax paying, patriotic American. That's me !

    Cats. Because People Suck.

    If someone has assisted you in any way, please be respectful to acknowledge it.
    Simply saying "Thank you" will suffice. If you are so moved, adding to their reputation by clicking
    <------ Add Reputation is a very nice gesture.
    When your question has been answered, Please mark the thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    05-05-2018
    Location
    Oakland, CA
    MS-Off Ver
    2016
    Posts
    252

    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)

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