Results 1 to 3 of 3

Expand "countif" fomula

Threaded View

  1. #1
    Registered User
    Join Date
    09-04-2007
    Posts
    2

    Expand "countif" fomula

    I’m trying to expand the countif formula listed below to count specific score values, ranging from 500 to 900, for 8 participants.

    For example:

    Current formula I’m using is
    COUNTIF (‘INDIVIDUAL RESULTS’! AE2:AE85, “>=499”)

    The results are contained in another worksheet titled “INDIVIDUAL RESULTS covering lines 2 to 85 across 8 columns. Looks like this

    AC
    Line 2-700 score
    3-655
    4-528
    5-612
    85-682


    So I’m trying to create separate formulae that will be displayed in 4 separate colums (500-600-700-800)for each individual for each of the following ranges:
    >=500 <=599 count only in that range AE2:AE85
    >=600 <=699 same AE2:AE85
    >=700 <=799 same AE2:AE85
    >=800 <=899 same AE2:AE85

    So can the original “COUNTIF” formulae be expanded to count > and > occurrences?
    Last edited by bluto89; 09-04-2007 at 03:22 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