+ Reply to Thread
Results 1 to 3 of 3

anomaly in COUNTBLANK funciton

  1. 10-24-2010, 12:39 AM #1
    venkat1926 is offline
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    anomaly in COUNTBLANK funciton

    I have entered 1 to 15 in E1 to E15
    in G1 I typed a formula
    =IF(E1<3,"",E1)

    copied G1 down upto G15

    G1 and G2 are blank . ok

    when I type in an empty cell in column G or any other column
    =COUNTBLANK(G1:G15)

    I get an answer 6

    mine is excel 2002 and windows XP.

    where did I do the mistake ???????
    Reply With QuoteRegister To Reply
  2. 10-24-2010, 12:53 AM #2
    grizzly6969 is offline
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: anomaly in COUNTBLANK funciton

    I'm using excel 2000 and I get answer 2
    Reply With QuoteRegister To Reply
  3. 10-24-2010, 03:59 AM #3
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: anomaly in COUNTBLANK funciton

    I also get answer 2...

    You could upload example file...

    Also, maybe you could use countif in E column directly : =COUNTIF(E1:E15,"<"&3)
    Never use Merged Cells in Excel
    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)

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