Results 1 to 6 of 6

Counting with Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-12-2008
    Posts
    2

    Counting with Criteria

    I have googled and oogles, but with the multitude of counting methods and I haven't found the answer I need.

    I'm trying to count the number of case entries (rows) where there are if certain values that can occur in EITHER column. In my example, I want to know how many cases have either A>3 OR B>10... which would be a total of 4 cases. I can get to work for AND but not OR. Please help. Thanks.

    A B
    3 10
    3 0
    0 0
    0 10
    1 0
    0 10
    0 0
    2 5



    Here's a link to what I'm trying to explain:
    http://img227.imageshack.us/img227/1...lsamplett7.jpg
    Last edited by JCM96; 05-12-2008 at 03:50 AM.

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