+ Reply to Thread
Results 1 to 3 of 3

Counting Blanks

  1. 08-23-2005, 09:26 AM #1
    T De Villiers
    T De Villiers is offline
    Forum Contributor
    Join Date
    08-20-2005
    Posts
    171

    Counting Blanks

    I need a formula which counts blanks within the range b1:b200

    Ive tried countif(b1:b200,0) or countif(b1:b200,"0")

    neither work, any help is much appreciated
    Reply With QuoteRegister To Reply
  2. 08-23-2005, 09:33 AM #2
    BenjieLop
    BenjieLop is offline
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by T De Villiers
    I need a formula which counts blanks within the range b1:b200

    Ive tried countif(b1:b200,0) or countif(b1:b200,"0")

    neither work, any help is much appreciated
    Try this ...

    =countif(B1:B200,"="&"")

    Regards.
    BenjieLop
    Houston, TX
    Reply With QuoteRegister To Reply
  3. 08-23-2005, 09:34 AM #3
    Leebo
    Leebo is offline
    Registered User
    Join Date
    08-22-2005
    Posts
    3
    This works too...

    =countif(B1:B200,"")
    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