Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: CountIF cell is Null

  1. #1
    Join Date
    12th April 2006
    Posts
    53

    CountIF cell is Null

    I am trying to do a COUNTIF the cell is not empty. Sometimes the value starts with a number but sometimes the value is a letter.
    I figured out how do one or the other but not both.
    =COUNTIF(E2:E65536,">""")
    =COUNTIF(E2:E65536,">0")
    Is is some how possible to combine them together.

    BTW, The post should be countif cell is not null..
    Last edited by Boriqua; May 8th, 2006 at 05:03.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: CountIF cell is Null

    Quote Originally Posted by Boriqua
    I am trying to do a COUNTIF the cell is not empty. Sometimes the value starts with a number but sometimes the value is a letter.
    I figured out how do one or the other but not both.
    =COUNTIF(E2:E65536,">""")
    =COUNTIF(E2:E65536,">0")
    Is is some how possible to combine them together.

    BTW, The post should be countif cell is not null..

    =COUNTIF(E2:E65536,"<>""") will do it.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    12th April 2006
    Posts
    53

    Re: CountIF cell is Null

    Thanks for the quick reply, But I am still having an issue it is counting the blank cell. Almost as if it would find the last used cell and make that the final value.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: CountIF cell is Null

    Quote Originally Posted by Boriqua
    Thanks for the quick reply, But I am still having an issue it is counting the blank cell. Almost as if it would find the last used cell and make that the final value.
    Ah, sorry, that's not what you wanted. This will work, but I expect someone will have a neater solution...

    =SUM(COUNTIF(E2:E65536,">"""),COUNTIF(E2:E65536,">0"))
    Last edited by ByTheCringe2; May 8th, 2006 at 05:41.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    12th April 2006
    Posts
    53

    Re: CountIF cell is Null

    Thanx, That one worked.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,326

    Re: CountIF cell is Null

    Hi,

    How about

    =COUNTA(A:A)

  7. #7
    Join Date
    12th April 2006
    Posts
    53

    Re: CountIF cell is Null

    Sweet...Thanx for your replys

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    9th August 2005
    Posts
    91

    Re: CountIF cell is Null

    Or my favourite friend...

    VB:
    =SUMPRODUCT(--(E11:E15<>"")) 
    
    
    "The greatest trick the devil ever pulled, was making his a figure of eight for each next loop"

    Free Excel Hints and Tips

  9. #9
    Join Date
    22nd November 2005
    Posts
    894

    Re: CountIF cell is Null

    Hate to Hijack, but what does the -- represent in a formula?

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    9th August 2005
    Posts
    91

    Re: CountIF cell is Null

    It changes a TRUE to a 1, or a FALSE to a zero...

    see this link
    http://www.ozgrid.com/forum/showthre...ighlight=MAXIF
    "The greatest trick the devil ever pulled, was making his a figure of eight for each next loop"

    Free Excel Hints and Tips

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. COUNTIF function does not work with blank or null cell
    By ByTheCringe2 in forum EXCEL HELP
    Replies: 11
    Last Post: July 15th, 2012, 10:08
  2. Empty Cell Versus Null
    By vbaman81 in forum EXCEL HELP
    Replies: 2
    Last Post: April 30th, 2007, 13:06
  3. Database Query Parameter, cell value, null or not null
    By abqa in forum Excel and/or SQL Help
    Replies: 7
    Last Post: August 21st, 2006, 22:15
  4. Leave Null Values as Null not Zero
    By petehenson in forum EXCEL HELP
    Replies: 12
    Last Post: October 25th, 2005, 01:37

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
  •  
porno