Results 1 to 5 of 5

weighted scoring formula to exclude not applicables

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    61

    weighted scoring formula to exclude not applicables

    Hi All,

    I am stuck big time with this. The attached shows a report to collect data for an evaluation. A score of 1 is entered against each category depending on the outcome of the call. The part where I am stuck is if a category is N/A I want the total percentage score to not take this into consideration. As an example. All the categories could score excellent with the exception of telephony skills which is N/A. In this case, the score is 96% but I want the calculation to only include those categories where the whole section is not N/A.

    Really hoping that someone can assist with this. I know there are enough bright sparks out there to dig deep and help me through this!!!
    Thanks in advance guys
    Attached Files Attached Files
    Last edited by sav1979; 06-12-2011 at 07:49 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