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.
Bookmarks