Closed Thread
Results 1 to 2 of 2

Conditional scoring and summing non-contiguous cells (leaving out the blank values)

  1. #1
    Registered User
    Join Date
    08-29-2010
    Location
    Athens
    MS-Off Ver
    Excel 2007
    Posts
    10

    Conditional scoring and summing non-contiguous cells (leaving out the blank values)

    Hi All,
    Please see attached spreadshseet which has 9 highlited non-contiguous variables which need to be 'scored' and then summed at the end of the row (score??).

    For each of ac1, ac2, ac3, etc. responses can range from 1 to 4 (although some are missing). I would like to be able to score total row sum using the the following criteria:

    if answer=1 or 2, then score = 1
    if asnwer=3, then score = -1
    if answer=4, then score=0
    if answer is missing (blank), then score= MISSING

    Using this scoring protocol, scores can range from -9 to +9. As you will see in the attached spreadsheet, however, some persons are missing one or two scores, whereas for others persons all values are missing altogether!

    Here is my problem. I want to be able to score each cell (see the 'ifs' above) and then sum across the non-contiguous columns to compute a final score WITHOUT counting the blanks as zeros. In other words, how can I add or SUM items up without Excel putting a darn 'zero' in the rows where there is no data?

    Hope I've explained this okay and thanks in advance for your help.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Conditional scoring and summing non-contiguous cells (leaving out the blank value

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Last edited by teylyn; 08-29-2010 at 10:46 PM.

Closed Thread

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