Results 1 to 3 of 3

Determining Positive responses, Tally them then group them

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2009
    Location
    Nairobi, Kenya
    MS-Off Ver
    Excel 2007
    Posts
    2

    Determining Positive responses, Tally them then group them

    I would like to determine values above a given threshold as positive. I have done this by having the values in one sheet (Raw data) and looking at them in the second sheet and giving any value above 150 a P value by using =IF('Raw Data'!D6>$A$1,"P",'Raw Data'!D6*1)(See attached).


    Now I would like to tally the number of P values (Positive responses) across the columns such that if Row One(1st responder) has no P value then it is 0. if one P then this returns a value of 1, etc.

    Then I would like to tally the different P responses for All the responders i.e. if there are four Responders having zero P responses thus this should return a value of 4 (Again see file)

    All your help in this will be highly appreciated.
    Attached Files Attached Files

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