Results 1 to 6 of 6

COUNTIF without counting blank cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2010
    Location
    Aarhus, Danmark
    MS-Off Ver
    Excel 2007
    Posts
    7

    COUNTIF without counting blank cells

    Hi,

    I am trying to build a model, but I have some problems.

    Say I have a row with data, like:

    Total:
    12
    10
    8
    5
    12
    5
    ect....

    I want to count how many of the numbers are > 9.5.

    I used this formula: =COUNTIF(F4:F22;">=9,5") , and it works fine.

    However, there is some missing data, that is gonna get added on the way. Like a bunch of blank/0 cells. Looks like this:

    Total:
    12
    10
    8
    5
    12
    5
    0
    0
    0
    0
    0
    ect....

    Is there any way to add something to the COUNTIF formula to exclude the blank cells from being counted?

    Any help is appriciated.

    Kasper
    Last edited by Melgaard; 03-03-2010 at 11:50 PM.

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