Results 1 to 4 of 4

COUNTIF values are > 0

Threaded View

  1. #1
    Dave F
    Guest

    COUNTIF values are > 0

    How can I use COUNTIF to count the values in a range which are greater than 0?

    I put =COUNTIF(B2:B100000)>0 but that didn't work?

    (I'm using XL 2007 hence the range greater than 65000 rows. But I don't
    think COUNTIFs syntax has been changed in 2007 so I assume I'm having a brain
    fart.)

    Thx,

    Dave
    Last edited by oldchippy; 10-24-2008 at 12:52 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