Results 1 to 4 of 4

Countif averages no blanks

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2013
    Location
    Nederland
    MS-Off Ver
    Excel 2003
    Posts
    38

    Countif averages no blanks

    Dear Excellers,

    I'm missing a piece in the following puzzle.

    I want countif to skip blank cells. Otherwise the averages aren't right.

    I made an example in the attachment.

    Thanks for your help in advance.

    psj
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. COUNTIF Statement ignore blanks
    By shanikakbrown in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-12-2014, 06:42 PM
  2. [SOLVED] Formula to Compute Averages - Ignore Zero (Blanks)
    By Neane in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2012, 07:08 PM
  3. Ignore blanks when using COUNTIF
    By mattmac in forum Excel General
    Replies: 3
    Last Post: 05-27-2011, 04:56 AM
  4. weighted averages using SUMIF and COUNTIF
    By rjallen in forum Excel General
    Replies: 4
    Last Post: 07-07-2009, 10:56 AM
  5. Ignore blanks using =SUMIF/COUNTIF
    By Casper9T9 in forum Excel General
    Replies: 10
    Last Post: 06-05-2009, 05:26 PM
  6. Countif and averages avoid blanks
    By padawon in forum Excel General
    Replies: 4
    Last Post: 11-13-2007, 06:08 PM
  7. COUNTIF sees blanks
    By savarin in forum Excel General
    Replies: 4
    Last Post: 11-04-2007, 05:04 AM

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