Determining Positive responses, Tally them then group them

**Mwanj** · 10-21-2009, 01:32 PM

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.

**DonkeyOte** · 10-21-2009, 02:53 PM

If you want to keep your table and simply populate column E and then totals below (frequency) then:

E6: =COUNTIF($B6:$D6,"P")
copied down to E24

D26: =COUNTIF($E$6:$E$24,ROWS(D$26:D26)-1)
copied down to D29

D30: =SUM(D26:D29)