Results 1 to 10 of 10

find overall score based on the number of criteria passed

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2019
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    6

    find overall score based on the number of criteria passed

    Here is my problem, I have a focus area that has criteria. On a regular basis, each site marks which criteria they have completed by marking yes/no. Each criteria is given a level between 1-4. if they say Yes to the criteria then they score that level on the criteria, if they say No then they score one level down. Here is an example, the first criteria is meeting attendance, and it's level is 2, if they meet this criteria then they score a 2, if not they score a 1. this continues for each criteria.

    I have this part figured out, but what i need help with is the overall score. this is a gatekeeper system, which means that their overall score is equal to the highest level that they have passed. So for example if they pass all the criteria except for the first one, the attendance criteria, then their overall score is a 1, because they haven't passed the 2 criteria. I need a formula that can evaluate the scores and come up with the correct overall score.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trying to find out the number of unique items based on criteria
    By Winnette in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2019, 12:34 PM
  2. [SOLVED] find highest number based on criteria and flag by X
    By Villalobos in forum Excel General
    Replies: 6
    Last Post: 06-14-2017, 02:55 PM
  3. Replies: 0
    Last Post: 05-22-2014, 04:02 PM
  4. [SOLVED] To find Number of weeks passed
    By ashishmac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2012, 01:40 AM
  5. Replies: 2
    Last Post: 03-20-2012, 06:30 PM
  6. Calculating score based on criteria
    By Kumara_faith in forum Excel General
    Replies: 6
    Last Post: 03-16-2009, 08:36 PM
  7. [SOLVED] How can I find last row and score which meets criteria?
    By colwyn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2009, 07:24 AM

Tags for this Thread

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