+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

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

    Hello everyone,

    I have data in an excel sheet and need to count blanks in column O, when that row is not blank in column C.

    I have tried a variety formulas using sumproduct, counta, countblank, countifs, etc and am getting nowhere. This seems like it ought to be simple!

    Any help is appreciated!

    purldiver

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Forumla to count blank cells in a column when another column in the same row is not bl

    Try this:

    =SUMPRODUCT((O1:O100="")*(C1:C100<>""))

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-04-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Forumla to count blank cells in a column when another column in the same row is not bl

    I can't smile at you digitally, but you just got a really big smile. Thank you so much!!!

+ 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