+ Reply to Thread
Results 1 to 4 of 4

Count rows with multiple null and not null criteria

  1. #1
    Registered User
    Join Date
    07-28-2014
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    2

    Count rows with multiple null and not null criteria

    Hi, hope someone can help with the, have been googling this for a while but no joy.

    I am using Excel 2007. I have a table of data and I want to count the rows where column A is not null and where column D is null. So it would like something like this:

    =SUMIFS(A1:A1000,IsNotNull,D1:D1000,"")

    Except that IsNotNull does not exist.

    Thanks.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,616

    Re: Count rows with multiple null and not null criteria

    Think you want COUNTIFS, not SUMIFS, but:

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    07-28-2014
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    2

    Re: Count rows with multiple null and not null criteria

    Thanks - can't believe I missed that - work a dream

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,616

    Re: Count rows with multiple null and not null criteria

    You're welcome. Thanks for the rep.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Multiple Criteria, 3 and one can have null value
    By LarryC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2011, 03:20 PM
  2. How to work with Null and Not Null Vales
    By frankee_gee in forum Excel General
    Replies: 1
    Last Post: 10-15-2009, 03:46 AM
  3. Code to replace null and not null strings
    By tigertim71 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2008, 05:07 PM
  4. Advanced filter - display null or non-null
    By Duddles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-26-2008, 11:17 PM
  5. Null, "null", vbNull, vbNullString, vbEmpty
    By jason.teen@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2006, 08:30 AM

Tags for this Thread

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