+ Reply to Thread
Results 1 to 12 of 12

How do i make my Countif function skip counting a blank cell

  1. 03-20-2014, 03:32 AM #1
    Renildrah is offline
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    How do i make my Countif function skip counting a blank cell

    Hi,

    What can i do to stop my countif function from counting data in a row that has a blank cell?

    Your response will be greatly appreciated.

    Thanks,
    Renildrah.
    Reply With QuoteRegister To Reply
  2. 03-20-2014, 03:37 AM #2
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How do i make my Countif function skip counting a blank cell

    Which formula are you using and in which column are the blank cells?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 03-20-2014, 03:43 AM #3
    Renildrah is offline
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How do i make my Countif function skip counting a blank cell

    Fotis,

    The formula is: IF(G4="",COUNTIF($AP4:$AP8,"Fair"))

    Column G is the one that has some blanks;
    Column AP is the one from which different categories (i.e. Poor, Fair, Good) should be counted.

    Looking forward to your quick response.
    Reply With QuoteRegister To Reply
  4. 03-20-2014, 03:48 AM #4
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How do i make my Countif function skip counting a blank cell

    Your formula in simple words says:

    If g4=blank, then count the cells in range ap4:ap8 that include the word "fair". So formula counts ONLY if G4="".

    What is wrong on that?
    Reply With QuoteRegister To Reply
  5. 03-20-2014, 03:52 AM #5
    Renildrah is offline
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How do i make my Countif function skip counting a blank cell

    What i actually want is for it not to count anything if there is a blank in cell G4.
    Reply With QuoteRegister To Reply
  6. 03-20-2014, 03:54 AM #6
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How do i make my Countif function skip counting a blank cell

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-20-2014, 04:19 AM #7
    Renildrah is offline
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How do i make my Countif function skip counting a blank cell

    What does <> mean
    Reply With QuoteRegister To Reply
  8. 03-20-2014, 04:21 AM #8
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How do i make my Countif function skip counting a blank cell

    Quote Originally Posted by Renildrah View Post
    What does <> mean
    Different
    Reply With QuoteRegister To Reply
  9. 03-20-2014, 04:41 AM #9
    Renildrah is offline
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How do i make my Countif function skip counting a blank cell

    OOoooh, ok. But it is not yet doing what i want. is there another approach to what i want to do?
    Reply With QuoteRegister To Reply
  10. 03-20-2014, 04:47 AM #10
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How do i make my Countif function skip counting a blank cell

    Attach a small sample workbook

    To attach a small sample workbook.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Reply With QuoteRegister To Reply
  11. 03-20-2014, 04:54 AM #11
    Renildrah is offline
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How do i make my Countif function skip counting a blank cell

    Please see attached as i had described earlier.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 03-20-2014, 05:00 AM #12
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How do i make my Countif function skip counting a blank cell

    in aq1, you have this formula.

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


    this gives 3 as result, which is correct because,...

    ap1,ap2,ap4 have the word "Fair"
    Reply With QuoteRegister To Reply
  13. 03-20-2014, 05:03 AM #13
    Renildrah is offline
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: How do i make my Countif function skip counting a blank cell

    But you realize in that D3 is blank and i do not want it to count it. That is the problem i am trying to get rid of.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to make Excel VBA to skip blank cells until a cell has a number
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-11-2013, 08:29 PM
  2. Need help to make VBA to skip rows that are blank
    By vnzerem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 05:55 PM
  3. What function can skip blank cells
    By Peter Kishiwa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2013, 08:11 AM
  4. IF function to make a cell blank
    By Rnye14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2012, 11:18 PM
  5. How to skip blank cells in Function for Rank in VBA?
    By Neight in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-24-2007, 02:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1